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
You will find instructions here.
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
> how do I do a pivot table with data that is on multiple worksheets?
Prev: Filter formula
Next: In Excel, conditional format (font red) referencing another ce