Create Drop Down Box populated by a List

[Ted_MD]

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

 

[L. Howard Kittle]

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