Macro to add rows and populate cells
 

Posting again since orignal may have been missed during the holiday break.

Any help with this would be welcomed and appreciated.

I have a list of products that is used to create an order. Some of the
products (not all) are complex and the vendor supplying the material breaks
certain items out into components when they invoice because the parts and
pieces ship at different times.

I need a macro that will:
1. Look for a keyword in the item number cell (always in the same column)
2. Add two rows below the item
3. Inherit values from the parent product (markings & quanity) and add new
description text.

Here is an example. (panelboard is one of a few products that will need the
same approach)

I have now:
Marking Qty Item Number
HLM 1 Panelboard, Type AE (101)
HLN 1 Panelboard, Type AE (101)
M1 1 Panelboard, Type AE (101)
M2 1 Panelboard, Type AE (101)
N5 1 Panelboard, Type AE (101)

Need to end up with:
Marking Qty Item Number
HLM 1 Panelboard, Type AE (101)
HLM 1 Back Box
HLM 1 Trim
HLN 1 Panelboard, Type AE (101)
HLN 1 Back Box
HLN 1 Trim
M1 1 Panelboard, Type AE (101)
M1 1 Back Box
M1 1 Trim
M2 1 Panelboard, Type AE (101)
M2 1 Back Box
M2 1 Trim
N5 1 Panelboard, Type AE (101)
N5 1 Back Box
N5 1 Trim


Thanks in advance!

Scott