I'm currently trying to make a somewhat automatic Layer maker in excel.
I'm creating layers in AUTOCAD and i want a register for them in excel where i can sort them and create a new one or find a old one.
I'm using 11 symbols between letters, numbers and "-".
What i would like is for me to be able to make the program recognize some of the letters and automatically write the full meaning of them in a another cell.
I would like for the yellow field on the right to read the yellow field on the left and translate the letter to a short phrase or a word. Same for blue, green might be allot of work or very difficult but at least yellow and blue.
(in this example every post is the same but I will add different types of fields and same goes for status)