Drop down box

[Madcat]

G'day all,

I want to create a drop down box for a roster spreadsheet.

I have never done this before can someone please help?

Example:

A                  B                     C            D     E        F        G       H            I       J
Name               Junior Club           D.O.B        Age   H [cm]   W [kg]   Debut   Position[s]  Years   Contracted Value 
Michael Ennis      Junee NSW             16/03/1984   28    176      88       2003    HK           1       $250,000 
Bronson Harrison   Five Dock NSW         10/10/1985   27    183      102      2004    SR           1       $225,000 
Beau Scott         Picton NSW            15/05/1984   28    184      98       2005    SR           1       $200,000 
Bryce Gibbs        Western Suburbs NSW   5/11/1984    28    188      107      2003    PR           1       $150,000 
Jeremy Smith       Runaway Bay QLD       14/04/1980   32    184      100      2004    SR           1       $150,000

I will make space on the spreadsheet where I can name the team
FB
WI
CE
CE
WI
FE
HB
PR
HK Michael Ennis
PR Bryce Gibbs
SR Bronson Harrison [Once I select Bronson Harrison or any player for that matter, I want to make it so I can't select that player again anywhere on this form]
SR Beau Scott
LK

INT Jeremy Smith
INT
INT
INT

Can somebody please give me instructions on how to do this.

Thanks for taking the time to read my post!

Cheers
Madcat

 

[Madcat]

Any body? Please, your help would be appreciated!

 

[Madcat]

Bump!

 

[Peter_SSs]

Sounds like you want the basics of Data Validation, so take a look here for a start.

 

[Madcat]

Sounds like you want the basics of Data Validation, so take a look here for a start.

Thanks for the reply Peter_SSs.

The problem I have is that I can only select the one column, where I want to select multiple columns - Example:

SR: Bronson Harrison
SR: Beau Scott

As they both SR under their respective position heading, plus I want if I want to select Bronson Harrison as the first SR, I don't want him to appear in the second SR.

 

[Madcat]

Please?

 

[Peter_SSs]

I'm not sure what you are saying about multiple columns, but re-reading your original post it appears you want the Data Validation drop-down list to only show players that have not already been selected. For that, here are two possible resources:

http://www.mrexcel.com/forum/showthread.php?t=349228
http://www.contextures.com/xlDataVal03.html

 

[Madcat]

Hi guys,

Thought I'd upload a screenshot on what I actually require:

I need data validation in each cell next to FB, WI, CE etc that corresponds to the Players per position table.

Once I select Michael Gordon at FB, he shouldn't be an option anymore as he is selected. With the Interchange, they can be selected by whoever is left on the Players per position table.

Thank you so much for taking the time and trying to help me with my request.

Cheers
Madcat

 

[Madcat]

Could someone please help me? Thanks