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.
|