Pivot table from diferent worksheets
 

How can I create a pivot table from data of 3 diferent worksheets ?
Thanks
Daniel

Pivot table from diferent worksheets
 

You can create a pivot table from the data on separate sheets (multiple
consolidation ranges), but the results may not be exactly what you want.
There's more information he

http://www.contextures.com/xlPivot08.html


Daniel wrote:
How can I create a pivot table from data of 3 diferent worksheets ?
Thanks
Daniel


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Pivot table from diferent worksheets
 

Daniel,

You can use a ODBC UNION query with three parts to point to each of
the three different worksheets (I assume they've got the same
format). This makes the data appear as if it is coming from a single
source so far as the pivot table is concerned. It's a wee bit messy
to do but could probably be automated relatively easily with VBA.

Ian

On 27 Jul, 21:48, Daniel wrote:
How can I create a pivot table from data of 3 diferent worksheets ?
Thanks
Daniel