Multiple hyperlinks from drop down list
 

Hi everyone,

I am an excel beginner and this is my first time posting on this site.
I have no experience with macros, and am only just starting to learn
the ropes of other basic functions.

Currently I have multiple worksheets set up. I want to create a drop
down box in a worksheet that has 5 car dealership names. From this
drop down box i want to be able to click on each one of these names and
have each one be a separate link to a different spot on a different
worksheet.

Specifically:

I have a worksheet called "Brand Names". On this worksheet i want to
create a drop down box that has the name of 5 car dealerships. When I
click on one of these dealerships (say markville chevrolet), i want it
to take me to the section Markville Chevrolet I have created in a
separate worksheet, "Individual Dealer". I need all of the links to go
to this individual dealer sheet, but land at different cell references
within the sheet.

Any help would be greatly appreciated,
THANKS ALOT

lauren