Forum Discussion

Andyshepas's avatar
Andyshepas
Copper Contributor
Sep 26, 2023

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 ...
excel
Formulas and Functions
Andyshepas's avatar
Andyshepas
Copper Contributor
Sep 27, 2023

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

SanthoshKunder's avatar
SanthoshKunder
Iron Contributor
Sep 27, 2023
From where should it source the data corresponding to the selected months?
  • Andyshepas's avatar
    Andyshepas
    Copper Contributor
    Sep 27, 2023
    I guess that’s part of the question. Do I need a separate table for the budgets amount?
    • SanthoshKunder's avatar
      SanthoshKunder
      Iron Contributor
      Sep 27, 2023

      Andyshepasyou should keep a distinct table for your monthly budget information. Kindly refer to the provided screenshot for guidance.

       

       

      • Andyshepas's avatar
        Andyshepas
        Copper Contributor
        Sep 27, 2023
        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

Resources