Drop down lists

[Vicki]

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!

 

[מיכ×ל (מיקי) ×בידן]

Name the info range as LIST and in the Data Validation type to: =LIST.
Micky

 

[MAK]

As far as I know a List cannot be created anywhere else except for in the
same worksheet. You can't even create a List in another worksheet in the same
workbook.

But for the second part of what you want, You can always use the Count
function and then the If function.

If you have master list of all the seminars, you can further use the
Conditional Formatting where you can highlight any seminar which has reached
it's full capacity.

 

[Mike Rogers]

MAK

For pre xl2007 and I imagine it still works the same.

A list for data Validation can exist within the same workbook and be used on
any worksheet. I make my lists in some out of the way place, name the range,
and then in data validation I select "List" under the "allow" drop down.
Under the "source" drop down I hit f3 and it gives me a window that shows all
my lists. I select the one I want and wall-ah I have a drop down that works
using a list in another worksheet!

Mike Rogers