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.
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.
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.
Bookmarks