Forum Discussion
Andyshepas
Sep 26, 2023Copper Contributor
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 ...
SanthoshKunder
Sep 27, 2023Iron Contributor
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?
- AndyshepasSep 27, 2023Copper ContributorHi,
Any ideas on what formula I would need.
Thanks,
Andy- SanthoshKunderSep 27, 2023Iron ContributorHi 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?
- AndyshepasSep 27, 2023Copper Contributor
Hi,
What I want to see is that when I change the month in the drop the budgeted amount in column C changes with the month selected.
Thanks,
Andy