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.