Hello All,
I have a large data table where each row consists of an independent ID#.
I want to create a pivot table out of this data, where the "ID #" is in the filer section.
For each ID number I filter on, I would like for excel to automatically create a new excel sheet with the resulting pivot table, with the sheet name being the ID number, formatted to my liking.
Is there a VBA code I can use?
I am using excel 2010.
Bookmarks