Our company needs a tool to build part numbers. Let's say that we build lawnmowers. I need everyone to be able to access some type of database type thing that would operate as follows:
There are several drop down menus for the class and subcategory, etc of a part.
For example, one drop down menu might say Manufactured Parts and Purchased Parts. The next drop down under purchased parts might have blades, handles, and wheels. So on and so forth. After having about 3 levels of menus, the next thing it would need to do is generate the next 5 digit number that's available. Every single part will be given the next number no matter what class it's in. No numbers will ever repeat.
To demonstrate, Manufactured Parts might stand for AB and blades might be DF. The next 5 digit number is 01567. So, one of our employees after doing the drop down menus sees excel pop out the following part number: ABDF01567.
Can excel do this?
Thanks.
Bookmarks