I have a workbook with several sheets. On each sheet I have a Pivot table and a regular table with data in it.
I would like to copy the table and the pivot table to create a new worksheet without having to relink the data source each time.
Thanks in advance!
You may consider to,
1) When moving the table to new worksheet. CTRL+Select the data file and move together
2) Copy and paste the data in new worksheet, then create the pivot table
Click * to reward me...
Thank you...
sorry but it wont work.
I cant redo the pivot table each time. I need a automatic way to copy the whole data and have the new pivot table linked to the new chart. the problem is that I cant make the table worksheet scoped.
What is the reason for copying the same data and make a new pivot table.
Why not work in 1 worksheet and refresh the pivot table?
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
I need weekly data. Every week I need a new chart and a new pivot table. Iwant to create a blank sheet and copy in and rename it every week
Yes, that is what you want.
My advice would be, make 1 sheet with all weeks in it.
Make 1 column that defines the weeknumber.
Then you only have to refresh the pivot table.
it wont work because I need an automatic way to be able to copy a full page and not need to refresh it each time. My problem is that I cant make my chart worksheet scoped.
thank you for trying to help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks