How can I limit the people using my spreadsheet to the list of client
names listed? My list works great, but instead of selecting Gino's from
the drop down list, they type in "Ginos." I've search Data Validation
and see the Warning message options, but not a limit to list option.

Also, I know if I have "Gino's" in the column cell once, then the next
time someone types "G" in a cell that "Gino's" will pop up. Is there a
way to have this happen the first time some types a "G?"

-Chuck-


--
Dropdown3
------------------------------------------------------------------------
Dropdown3's Profile: http://www.excelforum.com/member.php...o&userid=30321
View this thread: http://www.excelforum.com/showthread...hreadid=518753