View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ivan Koh[_2_] Ivan Koh[_2_] is offline
external usenet poster
 
Posts: 9
Default How do i create a drop down list from information on another works

Hi all,

Anyone has any idea on how to create a drop down list in worksheet a if the
selections for the list are found in worksheet b?

In the excel help it says, "If the list is on a different worksheet, enter
the name that you defined for your list in the Source box."

But which name are they referring to over here?

Thanks