Forum Discussion
Excel Formula
Hi,
As discussed please look at the below.
The issue I have is with the Dashboard tab.
Everything has a formula except Column C ‘Budgeted’ as this needs a monthly manual input and can change each month.
Row 3 is a drop down for the month but when I swap to a new month the ‘Budgeted’ amount does not change. So I need a formula for those amounts to change when the month changes.
Hopefully someone can help.
Thanks,
Andy
- As you said budgeted column(C) is a manual input column. Why would it update if there isn't a dynamic formula that responds to changes in the month dropdown menu?
- Hi,
Any ideas on what formula I would need.
Thanks,
Andy- Hi Andy- What would you like to see upon choosing a value from the month dropdown menu? I'm a bit confused. Would you want to see the values in Column C?
