Hi All,
I've been searching for the correct code that will create a blank pivot table from a new set of data on the active sheet.
I attempted to record a macro creating a pivot table but it looks for a specific workbook the next time I use it.
So I often paste a set of data into a new workbook and then select all the data on the active sheet, then inert pivot table. I would like a macro that will select all data on any sheet I currently have open and then insert a pivot table from that data into a new sheet.
I hope I'm being clear, thanks!
Bookmarks