selecting names from dropdown list

[dbuttery1]

Total moron here needs help with excel!!

Trying to figure out how to have a drop down list that would allow me to select from the list an input into a grid i.e. 100 names into a 10x10 grid.

And actually what would be even better would be to have headers in the list i.e. one list with both men and women listed together.

MEN
john
mark
...
robert
WOMEN
jane
lisa
...
meg

I would like for the list to eliminate names already used if possible.

Hope that i'm clear and someone can help me!

[Paul]

This site should help you create the drop-down list so that used names are removed from the list:

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

[dbuttery1]

appreciate the help still working with it but I'm very close