Excel sheet for decrypting historic product codes

Good morning everyone.

I need to assistance with an Excel sheet I've put together.

Long story short - we have a database of historic orders from an old system we no longer use and the product codes are 15 characters long but each character determines a certain characteristic of the product.

Example:

32AWE2B7SAWEC4S

Character 1:- Country Code
Character 2:- Width
Character 3:- Depth
Character 4 & 5:- External colour
Character 6:- Profile
Character 7:- Coating - External
Character 8:- Thickness of external sheet
Character 9:- Substrate (External)
Character 10:- Core type
Character 11 & 12:- Internal liner colour
Character 13:- Coating - Internal
Character 14:- Thickness of Internal sheet
Character 15:- Substrate (Internal)

I've currently got a simple spreadsheet set up so that I paste the relevant product code into column A and then columns B-N are setup with dropdown menus, each linked to a validation list which relate to the part of the code above.

I have to then manually go through the product code and drop down each menu option to the relevant number or letter so that I have a full product description.

Ideally I would like to code this so that I could paste the product code in and Excel automatically populates the adjacent cells based on the defined characters and lists.

Is this firstly something that's possible with VBA and if so, how complex is it to implement?

Thanks in advance
Rich

.
Hello.
I think the best thing would be for you to upload a test book to the Forum where we can clearly see a couple of examples of what you have and what you want to achieve.

Max Panel Code Identifier.xlsm

Here is a sample of the spreadsheet.

Please excuse how basic it is - it's literally something I cobbled together in a few minutes to help me.

Thanks
Rich

There is an inconsistency for the Profile list. The last three items contain more than 1 identification mark. What to do about it?

Artik

Thats brilliant - thank you CheeseSandwich.
I do see Artik's point - if the code has PB for the profile it throws an error for everything this column onwards. That's going to be awkward because there are some codes (albeit very few) with these slightly longer codes.

One other thing I wanted to check - I've got a rudimentary "Clear Contents" button to wipe any inputs off the form once finished. Not sure what to add to the vba module to stop it wiping the formulae and just the content.

Hi Cheese, I was just about to reply before you posted - I can't change the actual code numbers for each list as they are what was set in the system prior to us moving to a new system. So the codes PB and PC are important as they are what would be on some historical orders. Sorry, didn't mean to throw a spanner in the works!

Ignore - I just Alt-F11 and saw what you meant! Sorry, multitasking with too many things and didn't look properly!
Thankyou for your help - it is very much appreciated