Hello everyone, I have a macro that imports data from Access into sheet
and where the original file is over 65636 rows it creates new worksheet
(sheet2 etc) to cope with the overflow rows.

I want to be able to analyse all this data in a single pivot table. I
it possible to group the sheets together for the purposes of
pivot-table or do you need to write something in vba ?

Many thanks for your help.

Kind regards

Scott

--
scottwilson
-----------------------------------------------------------------------
scottwilsonx's Profile: http://www.excelforum.com/member.php...fo&userid=1112
View this thread: http://www.excelforum.com/showthread.php?threadid=26429