Instert Rows Based on Cell Value
 

Hello,

I could really use a hand on this one.

I have multiple lines of different products ordered by different
people. In each row in excel it shows the product that was ordered as
well as the quantity and some other information.

What I need to do is expand each row based on the quantity value.
Essentially if someone ordered 4 of a particular product i want a macro
to add three rows below it.

for i.e.

this:

Invoice # / Date / Quantity/
2532434 / 11/02/ 5

would turn into this:

2532434 / 11/02 / 1
2532434 / 11/02 / 1
2532434 / 11/02 / 1
2532434 / 11/02 / 1
2532434 / 11/02 / 1

so the macro will add 4 rows below the 1st to make a total of 5 rows

I essentially want to expand the quantity sold so each row shows a
quantity of 1

can anyone help me out with that?


--
derekrap
------------------------------------------------------------------------
derekrap's Profile: http://www.excelforum.com/member.php...o&userid=20656
View this thread: http://www.excelforum.com/showthread...hreadid=481013