Hi
I have a filtered pivot in Sheet1 that has a list of names.
I have Sheet2 that is the "template" to be copied.
I would like to use a macro to create a new worksheet of Sheet2 for each name in the pivot table.
In addition the sheet should be named that name, and also place that name in cell B3 of the sheet created.
It is important that only the visible/filtered names from the pivot are used to create new sheets.
If anyone can please assist me with this it would be appreciated.
Thank you,
I have a filtered pivot in Sheet1 that has a list of names.
I have Sheet2 that is the "template" to be copied.
I would like to use a macro to create a new worksheet of Sheet2 for each name in the pivot table.
In addition the sheet should be named that name, and also place that name in cell B3 of the sheet created.
It is important that only the visible/filtered names from the pivot are used to create new sheets.
If anyone can please assist me with this it would be appreciated.
Thank you,
