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

Please don't multipost.

If you really think you need to post to many newsgroups, then include them all
in your header and send the message once.

lauren_roberts08 wrote:

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

--

Dave Peterson