Good Evening,
I've attached a demo of a pivot table that selects the grand total and opens on a new sheet. I want to name the sheet before it opens to "Test Sheet". Currently it creates the sheet and labels it "Sheet1" which i cant have. Any assistance is greatly appreciated. Thx
Bookmarks