Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding rows based on a cell? | Excel Worksheet Functions | |||
Can no longer instert symbol in text box | Excel Discussion (Misc queries) | |||
Add Rows based on Cell contents | Excel Discussion (Misc queries) | |||
Macro / VB / Instert Date Question | Excel Programming | |||
Deleting Rows based on text in cell & formatting cell based on text in column beside it | Excel Programming |