Hi Ozgrid
I have a pivot table (PivotTable2) I would like a code that creates individual sheets (tabs) populated with the grand total data and are then re-named from the first row of the same pivot table. Hope this makes sense I have attached the excel sheet containing the pivot table.
Richard