Hi,
I'm new to this forum but have tried to search for a "clean" solution to my problem. I have an excel-based score sheet used for a weekly golf league. I am trying to use data validation to make entering the players for a given week more accurate and efficient. Data validation allows me to check against a list of all active players. This will catch typos and new players not in the "Active" list. Google docs has this great feature built into the data validation function that autocompletes based on the list of data used for validation. This is a GREAT solution as I can start typing a name, then select using mouse scroll + click or keyboard arrows + enter.

Is it really possible that nobody has come up with a clean implementation of this function in Excel? I've found some that use "Autocomplete", but I have to have my data in rows above where the data entry will occur. I really don't want to create, then hide 1250+ rows of data.

Is there a better way other than to convince my golf club members to start using Google Docs?

Thanks for any help!
-chawnskie