Hello,

I could really use a hand on this one.

I have multiple lines of different products ordered by differen
people. In each row in excel it shows the product that was ordered a
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 macr
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
quantity of 1

can anyone help me out with that

--
derekra
-----------------------------------------------------------------------
derekrap's Profile: http://www.excelforum.com/member.php...fo&userid=2065
View this thread: http://www.excelforum.com/showthread.php?threadid=48101