OK, the long and short of this... I have a football pool that has a tab for each week
I took the first column A (which is hidden) and listed every team, which made it easier to add a drop down box when setting up Who was playing who in column B, and C. The only thing is I have to click on the drop down and scroll to the correct team. So if Arizona is playing San Francisco... It is from the top to the bottom.

What I would like to do minimally is be able to just go to the cell in column B or C, and start typing the name and only the team names starting with the letter A would appear and also with S... Basically the more I type I can eventually hit enter and the right name populates.

Another thing, and I am not sure if this is possible, is once a team name is entered, it will NOT show up on the list as a choice... for instance by the time I get down to the second to last teams playing, then there would only be 4 team names left, 3, 2, then 1... that might require a lot of stuff.

I did do something fantastic with the rows, where if I set Arizona @ San Francisco... as I go along the rows to enter peoples selections, it will only show those two teams as options.

Any help you can offer with my first problem of setting the teams playing would be awesome.