Prev: Filter formula
Next: In Excel, conditional format (font red) referencing another ce
From: Stephanie on 19 May 2010 15:27
how do I do a pivot table with data that is on multiple worksheets?
From: Roger Govier on 19 May 2010 16:10
Hi Stephanie

You will find instructions here.
http://www.contextures.com/xlPivot08.html

But be aware, that you may not see the result as you expect.
It would be better, if you could first combine all of your data to a
single sheet (assuming your version of Excel can accommodate theta
number of rows).
For consolidating data from multiple sheets, take a look at
http://www.rondebruin.nl/copy2.htm

--
Regards
Roger Govier

Stephanie wrote:
> how do I do a pivot table with data that is on multiple worksheets?
 | 
Pages: 1
Prev: Filter formula
Next: In Excel, conditional format (font red) referencing another ce