Insert rows based on a value in a cell and copy the data down into the new rows

**eyeman96** · 05-05-2013, 06:59 AM

I am trying to find a VBA that can copy and insert rows based upon a value found in each row. I attached an excel workbook containing 2 sheets. The first sheet is the data sheet and the second sheet shows what I need the VBA program to do. Essentially column 13 has the quantity for the total duplicate rows (row 2 needs to have a total of 4 duplicate rows, row 3 needs to have a total of 2 duplicate rows, etc). Any help would be appreciated.

**AB33** · 05-05-2013, 07:38 AM

Try the attached.

**stanleydgromjr** · 05-05-2013, 07:54 AM

eyeman96,

See my reply #13 to your cross post here:
http://www.excelforum.com/excel-prog...-new-rows.html

Insert rows based on a value in a cell and copy the data down into the new rows

LinkBack

Thread Tools

Rate This Thread

Display

Insert rows based on a value in a cell and copy the data down into the new rows

Re: Insert rows based on a value in a cell and copy the data down into the new rows

Re: Insert rows based on a value in a cell and copy the data down into the new rows

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions