Drop Down Menu

[Gaya_385]

I created a drop down menu from data - validation and I'm wondering how to make it so that when a certain item is being selected, a list of information will be shown in another drop down menu....

[oldchippy]

This link should help?

http://www.contextures.com/xlDataVal13.html

[Gaya_385]

Hi your link was really very good ... but now i have another problem... i think i shall explain the whole senario...

ok i m actually trying to create a database for a school for the students to choose CCA (activities - which is abt 20 of them)... and there is a limit of 20 students for each activity... so its like first *** first serve kind of theory.. so right now wad i have done is that i have created a list(drop down box) where by the students can choose their class and base on their class they can choose their name.... they will be doing this in the respective activity sheet page which they will choose at the start .. so in this page there should be limit where it can onli take in 20 students.... how do i limit tat... and the problem is the whole class will sit in at the same time and use the same excel workbook do it...