Hiya

Is there a way I can create a drop down list but putting the info into
another worksheet?

Basically I am creating a way students can choose seminars for a conference
- and I want for when one conference has filled 20 places, say, an error note
appears saying that they need to choose another.

Not sure if I can even do this in Excel but probably someone will know!