Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a record in one worksheet from the data in another.
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Macro to Record Lap Times | Excel Discussion (Misc queries) | |||
Saving a worksheet as . prn text file - record length | Excel Discussion (Misc queries) | |||
Creating a data series using another worksheet? | Excel Discussion (Misc queries) | |||
What function would move a closed record to another worksheet? | Excel Worksheet Functions | |||
Creating a Pivot Table with data in more than one worksheet | Excel Worksheet Functions |