Hello, how can I insert individual hyperlinks (that is, hyperlink each item on a drop-down list) into a drop-down menu in a cell in a worksheet I am working with? I'd like the data it refers to to be located in another sheet. I don't simply want that cell to hyperlink to the entire other sheet; I would like the cell to offer a drop down list of which each item will take the user to the particular row of data to which that item refers.
Make sense?
I don't have any experience with Macros so if the answer includes them can you please explain in a step-by-step breakdown?
Answer needed ASAP - and MUCH APPRECIATED!
Make sense?
I don't have any experience with Macros so if the answer includes them can you please explain in a step-by-step breakdown?
Answer needed ASAP - and MUCH APPRECIATED!