Create Drop Down Box populated by a List
 

Would someone please tell me if I can Create a Drop Down Box populated by a
List from another Worksheet which will Select an item from the Drop Down Box
populated by the List from the other Worksheet as Input a given Cell. The
Drop Down Box should appear and work that way for any selected Cell.
thanks,
Ted

Create Drop Down Box populated by a List
 

Hi Ted,

You will need to name the list from the other sheet. So, select the list,
name it and then in the data valadation allow list and in source box enter
=TheNameOfTheList.

HTH
Regards,
Howard

"Ted_MD" wrote in message
...
Would someone please tell me if I can Create a Drop Down Box populated by
a
List from another Worksheet which will Select an item from the Drop Down
Box
populated by the List from the other Worksheet as Input a given Cell. The
Drop Down Box should appear and work that way for any selected Cell.
thanks,
Ted