I have a multi-tab spreadsheet and want to auto-populate data from one sheet to another sheet based on IF a value exists on first sheet.
On my first tab, 'Bill of Materials Pricing', IF Qty Exists in column "I", THEN would like to write the values from columns A, B and I from that particular row onto my 'Packing Sheet' tab in the first blank row available (starting in row 18):
PartNumber, Description, Quantity
For example, if in 'Bill of Materials Pricing' cell I9, I enter a quantity of "3":
I want the Part Number (A) from that row written to 'Packing Sheet' B18
I want the Description (B) from that row written to 'Packing Sheet' B19
I want the Quantity (I) from that row written to 'Packing Sheet' B20
Values would be something like this: 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.xls Anyone help me out on this one?
On my first tab, 'Bill of Materials Pricing', IF Qty Exists in column "I", THEN would like to write the values from columns A, B and I from that particular row onto my 'Packing Sheet' tab in the first blank row available (starting in row 18):
PartNumber, Description, Quantity
For example, if in 'Bill of Materials Pricing' cell I9, I enter a quantity of "3":
I want the Part Number (A) from that row written to 'Packing Sheet' B18
I want the Description (B) from that row written to 'Packing Sheet' B19
I want the Quantity (I) from that row written to 'Packing Sheet' B20
Values would be something like this: 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.xls Anyone help me out on this one?
