View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Anand vijay Anand vijay is offline
external usenet poster
 
Posts: 1
Default Dropdown Menu Hyperlink

Hi..
I want to create Hyperlink for list comming in dropdown menu. Lets assume
that there are 5 names in cell A1 to A5 and also their are 5 Sheets in the
files having those names. I create a dropdown menu and select the list of
name. Now if I choose The name comming in cell A2 than i should be able to
jump to a sheet2 and if i choose A that to Sheet 5. how do i do that?