-
Sep 13th, 2011, 08:39 AM
#1
Thread Starter
Junior Member
[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.
-
Sep 14th, 2011, 05:50 PM
#2
Hyperactive Member
Re: Excel Vba I’m need help with a copy sheet code!
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.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|