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
Bookmarks