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.
Pls use code tags around your code next time as per forum rules.