I created a macro to build a very boringly repetitive monthly pivot table but now the users want to have column headers change each month to separate Actual data from Forecast data.
So this month there would be Jan-Act, Feb-Act, and Mar-Act and the rest would be Mmm-Frct. Next month I need Apr-Act instead of Apr-Frct.
The data is structured with the each month being a separate column.
Any suggestions?
TIA,
me
So this month there would be Jan-Act, Feb-Act, and Mar-Act and the rest would be Mmm-Frct. Next month I need Apr-Act instead of Apr-Frct.
The data is structured with the each month being a separate column.
Any suggestions?
TIA,
me