I have a macro which creates the pivot table, copies and pastes the entire pivot table as values and formats in columns "J" thru "R'.
I then delete columns "A" thru "I" and have values which I can use.
My problem is the next day I update my data sheet, click on the macro and it creats another spreadsheet.
I deleted out the previous days sheet but it still identifies the new pivot table worksheet as the next sequincial sheet number.
I need a way to keep the same name on the new pivot table worksheet.