Creating a drop down list based on two cell values

[Storm_21_924]

Hey Guys,
I was hoping some of you might be able to help. Here's a tricky one...

Basically, This is a form for my soccer club, a line up card...

As my form is now,

I've got the positions laid out, Manually type player names in.
Example
Left Wing = E1
Right Wing = F1
Etc

Player list is pulled from another sheet and listed as a column.
For Example,
C40 = Player1
C41 = Player 2

now, D40, D41, etc autofills with either a "+" and Filled Green
(Conditional Formatting), or "-" and filled Red(Conditional
Formatting), based on the player availabilty from another sheet. If
the player is not available( "-" and Red), they are automatically
crossed out based on conditional formatting.

When I type a player name into one of the position, E1, the player
name in C40, etc automatically gets crossed out(conditional
Formatting).


Here's what I would like.. I would like to generate a drop down list
for each position, Say E1 for example, In the drop down I want all the
players listed that are not crossed out in D40.D41....Etc..

I Dont' know if this is possible.. If someone has any other ideas,
please feel free to share!

Thanks!
Shaun

 

[Pete_UK]

Debra Dalgleish has a lot of helpful stuff on Data Validation. Check
out this link in particular:

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

which shows how you can ignore previously-used items (equivalent to
your "crossed out" players).

Hope this helps.

Pete

 

[Storm_21_924]

Debra Dalgleish has a lot of helpful stuff on Data Validation. Check
out this link in particular:

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

which shows how you can ignore previously-used items (equivalent to
your "crossed out" players).

Hope this helps.

Pete












- Show quoted text -

Great, Thanks for link, I'll check it out and post back.

 

[Pete_UK]

You're welcome.

Pete

Great, Thanks for link, I'll check it out and post back.- Hide quoted text -

- Show quoted text -

 

[Storm_21_924]

You're welcome.

Pete





- Show quoted text -

- Update -

WIth a lot of tweaking and some layout changes I was able to get
everything accomplished!! Thank you for your help and passing along
the link. Very very Helpful!

Shaun

 

[Pete_UK]

Well, that's good to hear, Shaun - thanks for feeding back.

Pete