hyperlinking dropdowns

  • Thread starter Thread starter Emma
  • Start date Start date
E

Emma

I currently have a list of headings at the top of my
workbook which hyperlink to different cells, this is
because there are about a 1000 line entries and it's
quicker when catorgoised.

Instead of taking up all that room can I turn the list
into a drop down box that does eactly the same? If so how?

I can create the drop down but I can't get it to hyperlink
to anywhere. It's a bit like the drop downs on the
internet but only within the one work book.

Any help, advise and/or examples would be much appreciated.
Regards,
Emma
 
Thanks Debra but this didn't work. I need to have a
different hyperlink per item int he list. I'm writing up
a VBA code which hopefully will work although take me some
time as I'm a beginner i these areas.
Thanks again,
Emma
 
If you used Data Validation to create the dropdown list in cell B3, and
have the formula that I suggested:

=HYPERLINK("#"&B3,B3)

in cell C3, the hyperlink will change each time you select a different
item from the list. There are some instructions here for Data Validation:
http://www.contextures.com/xlDataVal01.html
 
Back
Top