When I use Data Validation to limit entries in a cell (lets say I am looking
for a day of the week), how can I let the user simply enter the letter M to
get Monday to automatically pop into the cell, and then have to Tab or Enter
to go to the next cell?

Also, how would Tuesday and Thursday be treated? 2 T's to get to Thursday
or TH to get Thursday?

Thank you,
--
Brad E.