Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro to Copy Pivot Table Data to Another Worksheet in Same Workbo
Hi Again Experts:
I have a project with tremendous impact if I can determine if it is possible to copy the first 10 lines of the data in a Pivot Table from the DropDown...Let me explain... I run a Pivot Table for 32 Locations...I need to select each location separately from the DropDown in the Pivot Table and copy the first 10 lines for that location to another separate worksheet which exclusive to that location...in other words, I have 32 separate worksheets besides the Raw Date worksheet and the Pivot Table...I do it manually now, but would like to do it with a Macro if it is at all possible. Is this possible? Any help you can provide would be greatly appreciated! -- jeannie v |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy worksheet and pivot table | Excel Discussion (Misc queries) | |||
Is there a way to copy a pivot table using a different data set? | Excel Discussion (Misc queries) | |||
Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
Macro to Synchronize data frm svrl workbooks & columns to 1 workbo | Excel Discussion (Misc queries) | |||
Copy worksheet with Pivot Table and break link to original workshe | Excel Worksheet Functions |