Creating a record in one worksheet from the data in another.

M

MichaelRobert

I have two worksheets. Worksheet A is used to create a 13 column Bill of
Materials from customer selected options. Each column contains up to 20
discrete Part Numbers, or None or #N/A.

I want to create a Record in Worksheet B if the customer selects this
particular configuration (Bill of Materials). I also want to allocate a Part
Number to the Bill of Materials (the next available number serially).

Any suggestions as to the best commands to use to do this?

Many thanks.

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

Top