pivot table refresh help

[jeancake]

I have a file with two pivot tables created from a data tab. every month I delete the data and replace it with new monthly data. The problem is that I have to go into each pivot table and open the wizard so that I can resize the range of the new data. I would like to create a macro that will automatically resize the range and update the pivot tables. Csn anyone help?

 

[Trouttrap2]

Another option to a macro is using the OFFSET function in your data range. This will create a dynamic range that expands the range each time new data is added. See this http://www.contextures.com/xlPivot01.html. This tutorial is text only. If you need a video, try this. http://www.youtube.com/user/ExcelIsFun#p/search/6/SEqKJ6s27Ac