How can I allocate a Part Number to a Bill of Materials?

M

MichaelRobert

I have a Bill of Materials for an Assembly that consists of 13 items. Each
item is itself a component Part Number, varying with color, voltage,
function, and position in the assembly. I have a worksheet that allows me to
enter these variables and to produce a 'volatile' Bill of Materials.The
particular BoM

What I want to do is the following:

1. If the assembly is ordered, I want to 'save' the 'volatile' BoM that I
have just generated to another worksheet.
2. I want to be able to assign a (serially-generated) Part Number to the BoM
that I just 'saved'.
3. I want the Part Number allocated to that BoM to show up on the 'volatile'
worksheet in the (unlikely) event that the same combination of 13 components
is generated.

I will appreciate any help on any of these three challenges.

Thank you.

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bill of materials 11
Creating a record in one worksheet from the data in another. 0
Excel - Compare spreadsheets and indicate matched data 4
Is it possible to edit colours already saved as part of a custom theme? 0
Importing XML bill of materials 4
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Bill of Materials 2
bill of materials query 1

Top