Try this,

At the beginning of the A codes enter a single A, do the same for the B
codes and all the way to Z.

Now go to the cell with the data valadation in it and type in the desired
letter, say it is R. DO NOT hit enter, leave the cell in the edit mode and
click the down arrow. Will take you to the top of the R codes. Select the
code number you want.

HTH
Regards,
Howard

"benji" wrote in message
...
in a cell I have Data validation with validation criteria to Allow List.
Now my list is a long list of 3 alphabet codes such as
ACE
AET
AMN
ARC
ARM
ASL
ATG
ATS
AUG
AWI
BBC
BEL
BRG
CBS
CDA
CEC
CHT
COP
CPT
CSM
CWT
CWT
DBA
DTK
when I do a normal filter I can go from one code starting with say letter
"A" to another code starting with "D" by simply pressing "D" on the
keyboard. This does not happen in this list. Is there some way I can make
it
happen.