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