Hi, thanks to andypope, i am now able to run a macro that will add worksheets for every value (sheet name) within a pivot table.

Please Login or Register  to view this content.
I have written another piece of code that would copy a "PasteData" sheet and for all values within A2:A7 would create a new sheet with the data found within the "PasteData" sheet but with the sheet name using a value from A2:A7.

Please Login or Register  to view this content.
I was wondering if their is anywhere i can combine the 2 codes so that the values from the PivotTable would create a new sheet but the content within the sheets would be devised from a template.

Is this possible? or is it just a case of amending the first code.

Can any1 please help.

Thanks in advance.