hyperlink from dropdown list

  • Thread starter Thread starter confused deejay
  • Start date Start date
C

confused deejay

hiya
i have 2 dropdown lists the 2nd list determend by the first (dropdown from a
dropdown) what i would like to do is hyperlink from this second list which is
based on the 1st.

i have at the moment =HYPERLINK("#"&B2&"!A1","GO")

but because b2 depends on a2 its not linking can anyone help please?? i've
tried =HYPERLINK("#"&A2:B2&"!A1","GO") and others but it returns #value.

please help i'm going crazy here lol .................
 
Presumably B2 is a sheet name - if this has spaces in it then you will
have to enclose it with apostrophes in your formula, so you might like
to try this:

=HYPERLINK("#'"&B2&"'!A1","GO")

Difficult to spot the differences, I know, but there is an apostrophe
' after the # and before the !

Hope this helps.

Pete
 
no b2 is a dropdown list it looks like this on the sheet....

a2 b2 c2
(dropdown) (dropdown)
January deejay paid OK (this should follow the hyperlink that
takes me to sheet "january deejay paid" where i can update the information)

the drop down in b2 is dependent on a2 as above should take me to "january
deejay paid" if a2 says "february deejay paid" it should go to that sheet.
 
What happened when you tried Pete's suggestion? Why didn't it work for you?

Regards,
Fred.
 
Are you sure you entered the apostrophes correctly? Have you verified that
the sheet exists?

Pete's formula should. I epxect you will find the error is one of the above.

Regards,
Fred.

confused deejay said:
it comes up reference not valid.
Click to expand...
 
its worked totally my fault and infact i now don't need the first dropdown
box which is great.
what i had done is hyperlinked my pages in the dropdown selection stage ie
deejay paid*hyperlinked to jan deejay paid. thinking the link could add the
two dropdowns together.
i've removed the hyperlinks and renamed my list to jan deejay paid* as per
sheet name and the link worked :)

thankyou for all your help guys
 
Back
Top