Newbie,
All you have to do is: Add any new sheet in the book and re-run the code. The code clears the old data and populate with the new ones. The code will include itself any new sheet name and new data.
What the code does not do:Automatically add new data in the summary with out hitting the F5 key.
You can also include the following code in the summary sheet, so where is change in the summary sheet, the PT will automatically refresh the data- so you do not need to keep refreshing the PT table.
To put this code:
Right click on the summary sheet- View code- copy and paste this code in the module. Please note this code not does not go in the standard module(unlike the main code). It goes in the summary code.
Please also note that you need to change this line of the code to suite your needs
("PivotTable1").
It refers to the name of the PT.
Bookmarks