WildfireS3
New Member
- Joined
- Nov 20, 2009
- Messages
- 11
Hi All
I'm a beginner to VBA, so please be gentle.
I have realsied that I can speed up a lot of my reports by automating them using VBA. However I'm a complete novice.
I have managed to get Excel to kick out 13 pivot tables to indivdual sheets, but now I want to consolidate these into one sheet.
I would like to copy the pivot table from each sheet, place it on to a new sheet, count 6 cells down then paste the next one in. So I end up with a master sheet with all 13 pivot tables on it.
Any takers?
Thanks
I'm a beginner to VBA, so please be gentle.
I have realsied that I can speed up a lot of my reports by automating them using VBA. However I'm a complete novice.
I have managed to get Excel to kick out 13 pivot tables to indivdual sheets, but now I want to consolidate these into one sheet.
I would like to copy the pivot table from each sheet, place it on to a new sheet, count 6 cells down then paste the next one in. So I end up with a master sheet with all 13 pivot tables on it.
Any takers?
Thanks