VBA for pivot table

VBA for pivot table

Cancelled

Job Description

I have attached a file with a pivot table. I would like to create a macro that does the following:

1. Change cell H1 to equal cell K2
2. Copy the pivot table (G1:G30) and paste special (as values) into the next worksheet, Sheet2
3. Change cell H1 to equal cell K3
4. Copy the pivot table (G1:G30) and paste special (as values) into Sheet3
5. Change cell H1 to equal cell K4
6. Copy the pivot table (G1:G30) and paste special (as values) into Sheet4

And repeat the above steps for all the Managers listed in column K.

Open Attachment