Macro to add rows and populate cells

S

Scott Wagner

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
 

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

Similar Threads

Macro to add rows and populate cells based on critera 0
Delete row that contains keyword 2
Macro, delete rows that meet criteria 4
VBA Help please (rookie issue) 6
Macro to copy cell values to row below 2
type mismatch error in macro in excel 0
Macro to Run Functions and VBA code??? 0
I want to take select cells from other rows (2 and 3) and combinethem with row 1 1

Top