Drawing Register Population

[LSElite]

Hey all

I am an autolisp coder and am trying to do some VBA coding for our drawing register.
Ive done some incredibly painful coding in excel to populate our drawing register from formulas but ive found that ive reached its limits.

So what I am trying to do is essentially replicate this drawing register with VBA so that i can keep adding to it.
what it does it read the drawing numbers from the first line and populate the drawing information from it.
eg: M13999-M-L00-101
-M- = MECHANICAL SERVICES
-L00- = LEVEL 00 or GROUND LEVEL
-1 = AIR CONDITIONING AND VENTILATION LAYOUT
01 = SHEET 01

I would like it if they would update on cell change aswell.

Ive attached the previous spreadsheet with the formula coding in it so you can get an idea of what im trying to achieve and maybe give me some advice on how to achieve this goal.
Im fimiliar with coding so even if I could get the basis of the code I can work with it to keep going.

Cheers

[protonLeah]

You should use VLookup tables to decipher the drawing numbers. Your posted example does not give enough info. I have formatted the sample workbook with blue cells where I started; but your IF formulas are difficult to decipher tonight.

[LSElite]

Cheers for that mate. I never even knew that vlookup existed. but i dont know if it will solve this problem.
what I need is a filtering system of sorts.
eg

m13999-M-000-001
IF eq -m- and -000- and -0 and 01
THEN eq legend and notes

IF eq -m- and -L00- and -1
THEN eq airconditioning and ventilation layout

IF eq -m- and -L00- and -0
THEN Demoltion Layout

I hope this is a bit clearer.

Cheers mate.