S
scottwilsonx
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
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