Add drop down list in cell

[MaxxFusion]

I found instructions on how to do this but I want to take it a step further. I havent been able to find how to do this or not sure what to search for.

In the drop down box after I make a selection I would like that choice to disappear from the drop down. So that way I dont select the same option twice. This would help out greatly when creating the order of my lists.

Is there a way I can do this?

 

[MaxxFusion]

On your Team sheet cell B1 change the formula to refer to column D instead of B on the LineUp sheet.

=IF(COUNTIF(LineUp!$D$9:$D$20,A1)>=1,"",ROW())

Seems to work for me now with that change.

Howard

Should I change all cell in B to use this code? But change A1 to A2 etc.

 

[L. Howard]

I put it in B1 and pulled it down.

So Team sheet cell B11 looks like this, after the pull down.

=IF(COUNTIF(LineUp!$D$9:$D$20,A11)>=1,"",ROW())

Howard

 

[MaxxFusion]

Should I change all cell in B to use this code? But change A1 to A2 etc.

I think its working now. I will test more. Then i will move onto doing all the other columns I want which looks to be a much bigger job.

 

[L. Howard]

Are you going to do columns E - K for fielding positions 1 - 9?

Howard

 

[MaxxFusion]

Are you going to do columns E - K for fielding positions 1 - 9?

Howard

Yes plus there will be 2 EH postitions because all 11 will bat in the order.

 

[L. Howard]

Okay, I'll dabble with it.

Howard

 

[L. Howard]

Hi MaxxFusion,

Here is my shot at it. You may have already got you workbook up and running, if so then dump this.

Found you will need to use EH1 and EH2 instead of EH EH, otherwise it wipes both clean when either is used.

I changed the formulas in the mirror line-up matrix (columns P - W) to eliminate the 0's.

Tested some, but you will need to see if it suits.


https://www.dropbox.com/s/8mp68090vl10x61/Drop Down Lineup-Card 7 Innings.xlsm?dl=0

Regards,
Howard

 

[MaxxFusion]

Hi MaxxFusion,

Here is my shot at it. You may have already got you workbook up and running, if so then dump this.

Found you will need to use EH1 and EH2 instead of EH EH, otherwise it wipes both clean when either is used.

I changed the formulas in the mirror line-up matrix (columns P - W) to eliminate the 0's.

Tested some, but you will need to see if it suits.


https://www.dropbox.com/s/8mp68090vl10x61/Drop Down Lineup-Card 7 Innings.xlsm?dl=0

Regards,
Howard

Thats exactly what I wanted. You are awesome.

Thanks so much. It will be so easy using this now.

 

[L. Howard]

Alright! Glad it worked for you.

Thanks for the feed back.

Regards,
Howard

 

[MaxxFusion]

Alright! Glad it worked for you.

Thanks for the feed back.

Regards,
Howard

I was playing with this a bit more this morning now that I had more time and it seems that the player names arent removed from the list once choosen.