PDA

View Full Version : Complex task in Pivot Table



Scadadude
12-10-2008, 10:11 AM
I may have confused the issue in the thread that shows this issue is solved. It is broken now and I will explain.

I have a pivot table and I am trying to automate the function where the items listed in Cloumn E are automatically selected for the pivot table and it just goes down the list and after each selection it copies the page to a new page in the workbook. So E2, E3, E4, etc each get selected in the pivot table under the Point Name portion of the Pivot table and then each selection copied to the new sheet.

Here is a sample of the Pivot table

Thank you so much for your help
Scadadude