Hi all,

I'm not sure whether it's possible, but I decided to ask it here
anyway.
I want to thank you in advance for any useful help. If it isn't
possible, just say so.

I created two dropdowns in separate columns using Data Validation.
I would want to link them in a dynamic way, i.e. I want to let the
input of the second dropdown, vary depending on the value that's
chosen from the first dropdown.

Boys John, Paul, Simon
Girls Anita, Linda, Sarah.

Boys in the first dropdown should give the boys names, and girls the
second row.
I wonder if there is a limit to the input range, for the real workbook
contains much more data than this little example.

Before I forget it, I'm working in a nt 4.0 environment with Office
2000.
There will be a migration to XP soon, so if it isn't possible yet in
Office 2000, but it is in XP, just tell me as well.