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

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

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.