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?

 

[L. Howard]

Indeed you are correct!

Go to Formulas > Name Manager > select NameCheck > Edit > Refers To: window > change the column to C instead of A in the formula.

Should look like this:

=OFFSET(Team!$C$1,0,0,COUNTA(Team!$C$1:$C$11)-COUNTBLANK(Team!$C$1:$C$11),1)

Howard

 

[MaxxFusion]

Indeed you are correct!

Go to Formulas > Name Manager > select NameCheck > Edit > Refers To: window > change the column to C instead of A in the formula.

Should look like this:

=OFFSET(Team!$C$1,0,0,COUNTA(Team!$C$1:$C$11)-COUNTBLANK(Team!$C$1:$C$11),1)

Howard

Ah thats makes sense.

Thanks Again. This sheet will save so much time.

 

[L. Howard]

Not sure why that was set to column A.

Regards,
Howard

 

[MaxxFusion]

Do you know where I can get a good excel file to track my team budget?

 

[L. Howard]

I googled and found this, and others.

https://www.dropbox.com/s/4gq103122v8a126/Sport Club Budget_Sample.xlsm?dl=0

If you cannot adapt this to your needs try a google search with:

Excel Sports Team Budget Templates

Howard

 

[MaxxFusion]

I googled and found this, and others.

https://www.dropbox.com/s/4gq103122v8a126/Sport%20Club%20Budget_Sample.xlsm?dl=0

If you cannot adapt this to your needs try a google search with:

Excel Sports Team Budget Templates

Howard

Thanks