Hi,
Need help to copy a sheet with Pivot Table.
1. In 'File 1' (Name of the File) - Sheet 1 has pivot tables and Data Source. Data is in A1:D100 and Pivot is in H1.
2. Using 'Move or Copy' sheet, I want to copy the entire sheet (Sheet 1) and save this file as 'File 2'
3. When i checked the Data Source of the Pivots in 'File 2', the data is picking from 'File 1'. I want this to be from 'File 2' automatically after save as new file.
Hope that my question is clear.
Thanks J
Welcome to the forum
Download the attached file and run the macro with {CTRL} k
The new workbook is saved to the same folder
Amend macro to suit your requirements
Since you are a new memeber it may help you to know this for the future:
Please Login or Register to view this content.
- read this page - it is very helpful
- it is helpful to see what you are looking at
- to attach a workbook click GoAdvanced\ look below & click ManageAttachments \ follow instructions in upload window
- always enclose any code in code tags (click on # icon above post area and insert code INSIDE the tags that appear)
- click on *Add Reputation to thank those who help you
Last edited by kev_; 04-08-2018 at 03:38 AM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
maybe use "new book"
nb.jpg
@sandy666 yes
-Sandy666 but with the new book, still the data source of the pivot will be from the main sheet
kev_ ; this will help me. thanks for your time
Got it
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
I have made the following changes to the code.
- Copy & Save Multiple sheets from the workbook
- Change the data source of more than one Pivot tables in the saved sheet.
do you have any other suggestions for the code below:
Thanks.Please Login or Register to view this content.
Last edited by vmjamshad; 04-09-2018 at 03:23 AM.
Is your new code working correctly?
Yes Kev_Originally Posted by kev_
Please see the file attached with the code.
In that case, the only thing I would change is to use the variable wbSt
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.Please Login or Register to view this content.
Last edited by kev_; 04-09-2018 at 05:32 AM.
I have changed, thanks. I have the same issue with Slicer also. Let me try, if not succeed , then I wd ask help here again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks