Hi
in the pivot table wizard you could choose 'multiple consolidation
ares' in the first dialog
--
Regards
Frank Kabel
Frankfurt, Germany
"scottwilsonx" schrieb im
Newsbeitrag ...
Hello everyone, I have a macro that imports data from Access into
sheet1
and where the original file is over 65636 rows it creates new
worksheets
(sheet2 etc) to cope with the overflow rows.
I want to be able to analyse all this data in a single pivot table.
Is
it possible to group the sheets together for the purposes of a
pivot-table or do you need to write something in vba ?
Many thanks for your help.
Kind regards
Scott.
--
scottwilsonx
---------------------------------------------------------------------
---
scottwilsonx's Profile:
http://www.excelforum.com/member.php...o&userid=11128
View this thread:
http://www.excelforum.com/showthread...hreadid=264299