Multiple hyperlinks from drop down box
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 |
Multiple hyperlinks from drop down box
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 |
All times are GMT +1. The time now is 01:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com