View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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