How do i create a drop down list from information on another works

  • Thread starter Thread starter Ivan Koh
  • Start date Start date
I

Ivan Koh

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
 
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
Click to expand...


Create a named range on the sheet where the list is kept. Include
blank rows if you think the list will be expanding. Then place
"=NamedRangeName" where the named rage is the name you gave your range,
in the validation data box for a "drop down list" choice in the data
validation dialog.



No parentheses, of course on the =rangename statement.
 
Back
Top