Create Drop Down Box populated by a List

  • Thread starter Thread starter Ted_MD
  • Start date Start date
T

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
 
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
 
Back
Top