My boss does not use pivot tables and instead creates copies of tabs each month/week for adding new data, but maintaining past figures. When I use Pivot tables I would like a way to keep a snapshot of the pivot results and then refresh new separately on a new dated dated so that a chronological history can be kept (and to keep boss happy for not too much change). Is there a way to not have all tabs in a worksheet refresh? I find I end up saving the workbooks by date, but this is not convenient when you want to easily compare refer back several months.
Typically to capture certain time periods I would use a date updated tab, but if I were to go back and change figures from the past I would want them to show on the new report, but not have prior reports refresh as it will not show what was actually reported. Not sure this makes sense, but hoping someone has some tips.
Typically to capture certain time periods I would use a date updated tab, but if I were to go back and change figures from the past I would want them to show on the new report, but not have prior reports refresh as it will not show what was actually reported. Not sure this makes sense, but hoping someone has some tips.