Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
drop down menus and corresponding hyperlinks
Hello World,
In my spreadsheet I have a series of cascading drop down menus. I would like it if I could drop down cell A9 to select "1120e" and when you do that cell A10 provides a link to another tab in the spreadsheet or to another document. That link depends on what you selected in A9. Thanks, Kim |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
drop down menus and corresponding hyperlinks
This could be done, but how would "1120e" indicate where to jump to?
Do you have a list of items that could be selected in A9 (you must have for the drop-down to work) and a related list showing where they would link to? Pete On May 6, 6:25*pm, Kimmie40 wrote: Hello World, In my spreadsheet I have a series of cascading drop down menus. *I would like it if I could drop down cell A9 to select "1120e" and when you do that cell A10 provides a link to another tab in the spreadsheet or to another document. *That link depends on what you selected in A9. Thanks, Kim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down menus | Excel Discussion (Misc queries) | |||
Drop down menus | Excel Worksheet Functions | |||
Drop down menus | Excel Worksheet Functions | |||
drop down menus | Excel Discussion (Misc queries) | |||
Drop down menus | Excel Discussion (Misc queries) |