Create Drop Down Box populated by a List

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
 
L

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top