pivot tables
I have a group of people that access an excel spreadsheet that
containsaccounting data for each ones clients.Each person pulls their data out of the spreadsheet and copies it to another sheet for review. I would like to create a macro that will drop their data automatically into a pivot table and then create a pivot chart. Can someone assist? When I try to record this I get an error ref the pivot table. |
pivot tables
Hi,
Why don't you show us the code and tell us where it fails? -- If this helps, please click the Yes button. Cheers, Shane Devenshire "massa" wrote: I have a group of people that access an excel spreadsheet that containsaccounting data for each ones clients.Each person pulls their data out of the spreadsheet and copies it to another sheet for review. I would like to create a macro that will drop their data automatically into a pivot table and then create a pivot chart. Can someone assist? When I try to record this I get an error ref the pivot table. |
All times are GMT +1. The time now is 06:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com