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

How do i create a drop down list from information on anotherworks
 

Basically, you define a named range to refer to the data in worksheet
b, and use this name. Debra Dalgleish gives detailed instructions
he

http://www.contextures.com/xlDataVal01.html

Hope this helps.

Pete

On Apr 28, 9:58*am, Ivan Koh
wrote:
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

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

On Tue, 28 Apr 2009 01:58:10 -0700, Ivan Koh
wrote:

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


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.