Selection of Drop down list that allows you to go to a particular cell
Hi all,
I need help to do the following thing:
1. Have a drop down list (e.g. Scenario 1, Scenario 2, Scenario 3)
2. When user select (e.g. Scenario 2) from the drop down list and click
on a "Go" Button, it will take the user to the cell that says Scenario
2.
3. There will only be one Scenario 2 in the whole sheet.
Thanks a lot.
|