Go to certain sheets based on cell value

  • Thread starter Thread starter tushargarg729
  • Start date Start date
T

tushargarg729

Hello,

I have created a drop down list with the numbers 1,2,3. If the user
chooses 1 and presses enter, he/she is taken to 'AOA Only Analysis'
sheet, and so on for the other two. Any and all help on this is
greatly appreciated.

Tushar
 
Tushar,

Instead of a drop-down, why not put your three entries in three cells? They
can have anything in them, such as "AOA Only Analysis." Now set up
hyperlinks (right-click the cell, and select "hyperlink") and set up the
hyperlink with "Place in this document."
 
The reason i have the drop down is because i am using the choose
function in the worksheets. based on the selection, certain
logic/decision rules take place. thats why i have to use the drop down
list. thanks
 
Tushar,

Then I think you'll need a macro to switch to the sheet you want. The logic
for selecting the sheet could be in the macro, or in formulas as you have
now.
 
I am trying this with a macro

Below is part of my code, however this doesnt work:

IF(Worksheets("Budget Analsysis").Range("A2").Value=1) Then
Worksheet("AOA Analysis").Range("A1").Select
Else
..
..
..

Hope this helps, thanks again
 
Tushar,

IF(Worksheets("Budget Analsysis").Range("A2").Value=1) Then
' If you got an error on the above line, it may be that the worksheet name
is misspelled.

Worksheet("AOA Analysis").Select
' select the sheet before you select the range

Worksheet("AOA Analysis").Range("A1").Select

Else

If you still have trouble, tell us more. Did nothing happen? Did you get
an error? What line? Did you breakpoint a line in the code to ensure the
macro is getting fired? Did you stand up and turn around three times?
Seasoned programmers know this stuff.
 
Earl,

Thank you for all your help. The macro works like a charm. Thanks
again

Tushar
 
Back
Top