I have a multi-tab spreadsheet and want to auto-populate data from one sheet to another based on IF / THEN.
On my first tab, 'Bill of Materials Pricing', IF Qty Exists in column i, THEN I would like to write the following fields from that particular row onto my 'Packing Sheet' tab in the first blank row available:
PartNumber, Description, Quantity
For example, if in 'Bill of Materials Pricing' cell I9, I enter a quantity of "3":
I want the Part Number from that row written to 'Packing Sheet' B18
I want the Description from that row written to 'Packing Sheet' B19
I want the Quantity from that row written to 'Packing Sheet' B20
TOD3060 30" x 60" Table Frame 3
Then I want the macro to look for each additional cell with quantity in column I and do the same - adding the Part Number, Description and Qty to the next blank line on the 'Packing Sheet'.
See my attached spreadsheet...DSG TRANSFER MASTER v7.xlsAnyone help me out on this one?
Bookmarks