Is there any way I can do the following with a drop down list? If not please help me find a way around this!
To start off I have a tab with different scenarios - let's say 3 - with an on/off filter for each. So Under each scenario I have a unique drop down list with options "on" and "off"
If "on" then I want to use this scenario and anything related to this scenario in my analysis
If "off" then I don't want to use this scenario or anything related to this scenario in my analysis
The three scenarios create my list for the drop down I am having issues with.
On a different tab is where I have my expenses. In order for my expenses to flow properly I have included drop downs under a column called "scenarios" pulling from the tab mentioned above
Here I can specifically allocate expenses to a scenario. The purpose of this is if I want to turn off a scenario, those specific expenses go away with it.
The issue I am running into is if I turn on a scenario 3 and then add expenses to it and then later decide to turn scenario 3 off - my drop down on the expense tab still shows scenario 3 is selected and that means my costs will still be there. When I click on the dropdown, scenario 3 isn't an option anymore - which is good and shows that it is working properly, however if I turn off the scenario I need that dropdown box to show nothing.
Very important - If I turn off scenario 3 and then turn it back on, I need that drop box to "know" that it was previously selected as scenario 3
is this possible?!!?
PLEASE HELP!
To start off I have a tab with different scenarios - let's say 3 - with an on/off filter for each. So Under each scenario I have a unique drop down list with options "on" and "off"
If "on" then I want to use this scenario and anything related to this scenario in my analysis
If "off" then I don't want to use this scenario or anything related to this scenario in my analysis
The three scenarios create my list for the drop down I am having issues with.
On a different tab is where I have my expenses. In order for my expenses to flow properly I have included drop downs under a column called "scenarios" pulling from the tab mentioned above
Here I can specifically allocate expenses to a scenario. The purpose of this is if I want to turn off a scenario, those specific expenses go away with it.
The issue I am running into is if I turn on a scenario 3 and then add expenses to it and then later decide to turn scenario 3 off - my drop down on the expense tab still shows scenario 3 is selected and that means my costs will still be there. When I click on the dropdown, scenario 3 isn't an option anymore - which is good and shows that it is working properly, however if I turn off the scenario I need that dropdown box to show nothing.
Very important - If I turn off scenario 3 and then turn it back on, I need that drop box to "know" that it was previously selected as scenario 3
is this possible?!!?
PLEASE HELP!