Drop Down list from a different worksheet
 

I want to have a drop down on a worksheet populate from another worksheet in
the same workbook. The Help instructions tell me that it can be down but
when I follow the instructions I get a message telling me it can't be done.
Very confusing. Does anyone know which is right?

Drop Down list from a different worksheet
 

It can be done, as long as you name the range that contains the list or
items. There are instructions he

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

Boo wrote:
I want to have a drop down on a worksheet populate from another worksheet in
the same workbook. The Help instructions tell me that it can be down but
when I follow the instructions I get a message telling me it can't be done.
Very confusing. Does anyone know which is right?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Drop Down list from a different worksheet
 

Watch this 5 minute video:

http://youtube.com/watch?v=t2OsWJijrOM

--
Biff
Microsoft Excel MVP


"Boo" wrote in message
...
I want to have a drop down on a worksheet populate from another worksheet
in
the same workbook. The Help instructions tell me that it can be down but
when I follow the instructions I get a message telling me it can't be
done.
Very confusing. Does anyone know which is right?