I have a "Pivot Table" with 6 columns A thru F. header = Fiscal Years. There is a row A thru F for total costs in each Fiscal Year. I have defined that range/row as Total Costs. I want to take each Total Costs and bump it up by an inflation rate without have to go in each cell and add the inflation rate after each refresh of the pivot table.
If I create a data validation drop down list with various rates of inflation how can I have that range name "Total Costs" recalculate for each cell based on the percentage of inflation chosen in the drop down list.
Any help is appreciated.
Thank you
Gene
If I create a data validation drop down list with various rates of inflation how can I have that range name "Total Costs" recalculate for each cell based on the percentage of inflation chosen in the drop down list.
Any help is appreciated.
Thank you
Gene
