Pivot Tables - need to do separate pivot tables for multiple sheets in same format

Hi all.

I have sales data for 30 salespeople on 30 sheets. I want to select sheet TCONNELL for example, do Pivot in specific format and then rename the new sheet as tconnell pivot and then go on to next sheet and replicate for next sales person etc

I have the names of the salespeople on a separate sheet and select as below. When I use a macro to record the pivot, it uses the name of the sheet in the macro, not the dummyname summaryname I set up and when I replace the actualname with summaryname, I get an error. Any assistance would be greatly appreciated.

TC.

Please Login or Register  to view this content.

Moderator Note:

Pls use code tags around your code next time as per forum rules.