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

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