I have 30 sheets of data each named after a region and need to make a pivot for each in a silimar layout
I create a temp file, copy the data into the tem, do the pivot, delete the temp and repeat
However, the source data for the pivot is the TEMP file
Need it to be the original file so
if summaryname is the variable name that loops around (region 1,2,3 etc)... can I replace TEMP1 with the variable summaryname?
Please Login or Register to view this content.