OK,I have a spreadsheet that I add data to one sheet (lets call this "Data" on the tab) and I always put the data in row 2 - moving all previous data down.



Now this data is tied to a sheet that has monthly pivot tables. This sheet we can call "PivotSheet".

So, I have tried to find a way to get all the pivot tables on the "PivotSheet" (they are not contiguously numbered) and have them update from the "Data" sheet with a vba script. But I have not found anything that points me to doing this.

IF someone could help that would be wonderful!

Thanks
E

Google says https://stackoverflow.com/questions/...k-with-a-macro

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post