Dropdown list

[Guest]

I have a soccer schedule sheet that list referees that I manual input. Would
like to know how to draw from another worksheet the referees I use. In
other words , I need a drop list that list all my referees on the main sheet.
What can I do.

 

[Guest]

Name your list of referees "Referees" (Insert=>Name=>Define...)

For your drop down list:

Select cell
Data=>Validation==>Allow: List==>Source: "=Referees" (no quotes)

HTH

 

[Guest]

Thank you so much. I have been working on this for weeks. You are a genuis!...