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 ...
From where should it source the data corresponding to the selected months?
I guess that’s part of the question. Do I need a separate table for the budgets amount?
Andyshepasyou should keep a distinct table for your monthly budget information. Kindly refer to the provided screenshot for guidance.
- Yes, makes sense thanks. I guess the only thing I’m missing is how do I get the table to reference the drop down so that when you change the month it automatically selects the correct numbers. Thanks
- The formula I provided already accounts for this. It references the month field. However, ensure that your 'budget' data follows the format shown in the screenshot above.