[RESOLVED] Excel Vba I’m need help with a copy sheet code!

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.

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.

I would appreciate any assistance with this code.

Thank you.

So are you wanting them to be able to update the data on the original?? If thats the case you should just create 2 separate workbooks. One with the data, and the other with the pivot table. You can link the pivot table to the data from the other workbook.