I'm creating a drawing register for a project i'm working on. An
example of the existing number system is BMI8813A where BM is the Site
code, I is a drawing type , 8 is a drawing identifier, 81 is an
equipment identifier and the 3A i'm still trying to figure out.

There are 63 different drawing types and approx. 30 different drawing
identifiers.

I have a list of drawing types with the 2 letter code and the drawing
description. I would like the register to have a pull down box that
displays the drawing type description but when selected adds the 2
letter code in the spreadsheet.

I'd prefer to stay away from VBA and combo boxes to make it easier for
the users filling in the register.

I'm not sure that the data validation is the correct way to go.

Thanks for any help

B