Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
Pivot Tables -changing datasource for exsting Pivot Table | Setting up and Configuration of Excel | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |