Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple sheets into 1 pivot table
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple sheets into 1 pivot table
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table from multiple sheets? | Excel Discussion (Misc queries) | |||
Pivot Table with Multiple sheets | Excel Worksheet Functions | |||
Pivot table for multiple sheets | Excel Discussion (Misc queries) | |||
Pivot Table from multiple sheets | Excel Discussion (Misc queries) | |||
Pivot Table--How can I create from multiple sheets? | New Users to Excel |