Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Rows Macro
Hello,
I couldn't find a macro that does this, so if anyone can point me in the right direction I would appreciate it: Sample Data: Product Code Qty ABCD AXD 2 DJFL DFY 3 Basically I want the macro to look at the quantity and recognize 2 and then insert 2 rows after ABCD, where the ABCD & AXD would be copied and the number 1 entered in the Qty for all the rows. So basically, data would then look like: Product Code Qty ABCD AXD 2 ABCD AXD 1 ABCD AXD 1 DJFL DFY 3 DJFL DFY 1 DJFL DFY 1 DJFL DFY 1 Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro to insert rows | Excel Discussion (Misc queries) | |||
how do I create a macro to auto insert rows? | Excel Worksheet Functions | |||
asking again, macro to insert rows | Excel Worksheet Functions | |||
insert rows in excel spreadsheet via macro | Excel Worksheet Functions | |||
Excel Macro to insert rows in a list | Excel Worksheet Functions |