I have a workbook with many sheets one of the sheets is a Pivot Table. I would like to give the user the option to create a new sheet with the pivot table sheet and the sheet that contains its source data only.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
> </o
>
This would allow them to continue to work without the large workbook needing to be open. This code will be run from the pivot table sheet.
<o
> </o
>
I would appreciate any assistance with this code.
<o
> </o
>
Thank you.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com




This would allow them to continue to work without the large workbook needing to be open. This code will be run from the pivot table sheet.
<o


I would appreciate any assistance with this code.
<o


Thank you.