Update pivot tables on sheet

[fredep57]

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

[Pecoflyer]

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