Taryn
New Member
The context:
*I have a P&L where the figures are already populated with formulas.
*I have a separate sheet with a number of cost improvement plans spanning across multiple months
*I would like the user to be able to choose 1 or multiple plans by month to see what affect it will have on the P&L if they are achieved
What's the best way to go about this please?
I toyed with What-If Analysis but it seems quite limited and doesn't allow for formulas
Ideally I would like the user to be able to select 1 or multiple plans from a validation list in E2 (Which I've done) and for that action to adjust the relevant cells within the P&L with the amount in the selected plans
Any help would be greatly appreciated
*I have a P&L where the figures are already populated with formulas.
*I have a separate sheet with a number of cost improvement plans spanning across multiple months
*I would like the user to be able to choose 1 or multiple plans by month to see what affect it will have on the P&L if they are achieved
What's the best way to go about this please?
I toyed with What-If Analysis but it seems quite limited and doesn't allow for formulas
Ideally I would like the user to be able to select 1 or multiple plans from a validation list in E2 (Which I've done) and for that action to adjust the relevant cells within the P&L with the amount in the selected plans
Any help would be greatly appreciated
Last edited: