I am an engineering student doing some vacation work at a manufacturing company. I am busy setting up a "Production Instruction" Sheet from where a person can configure a product which then displays in the "Item code" cell.
Please see the attached screenshot.
My product configurator consists of category, product, specifications, material and colour. These are drop down-lists from which I can choose a combination. Every drop down item has an associated code for witch eventually an 11 digit code is formed by concatenating the individual codes from the respective categories.
The "Item code" cell is then set = to the "unique product code" cell to have it the show in the production instruction lists. This I have managed to do.
Now, when I do a new configuration, the code obviously changes and then the code in the Item code cell also changes. I would like to have it stay there and when a new configuration is done, to display it's unique code below the previous code in the list. Is there any way this could be done? Would I have to use vba? ( For witch I have very limited experience). Or are there any work arounds?
I hope you can see what I am trying to explain. Any feedback would help a-lot! Thanks in advance :)
rsz_1screenshot_2022-06-21_at_172546.png
Bookmarks