Hi all,
I'm having a problem when recording a macro, which includes selecting a item (scenario) from a dropdown list.
In the end i want to update my the outcomes of my scenario analyses. The model is linked to one of the three scenarios, which can be selected from the dropdown. So, after recording a macro which selects a scenario, copy the outcomes to another location, then selecting another scenario etc it doens seem to work. Potentially as it does not recognize the list? problems with multiple worksheets?
Can anyone help me with this issue?
Would me very helpfull!!
Ank
I'm having a problem when recording a macro, which includes selecting a item (scenario) from a dropdown list.
In the end i want to update my the outcomes of my scenario analyses. The model is linked to one of the three scenarios, which can be selected from the dropdown. So, after recording a macro which selects a scenario, copy the outcomes to another location, then selecting another scenario etc it doens seem to work. Potentially as it does not recognize the list? problems with multiple worksheets?
Can anyone help me with this issue?
Would me very helpfull!!
Ank
