I have 15 pivot tables in my workbook. Each month I have to manually change the month in the filter to get the current months' data reflected. Is there any way to automate this process?
ie I have pivot tables for sales to different locations, different salesman, etc. and once I finish inputting the data for December I need all of those pivot tables to update with the December data. Right now, I am going to each pivot table and clicking on the drop down for month and choosing December. Is there any way to change all of them at once?![]()
Bookmarks