Moving Cells and Inserting a New Row

Hello all,

Trying to write a macro that will move cells in a row to a new row once they go beyond a certain point. In the attached example DatesWrap, you’ll see 5 sets of start and end dates (Periods 1-5). These will always be labeled as they are in rows 1 and 2 of the header. However, you’ll also see in cols L-O several other sets of start and end dates. If there are dates beyond the 5th set of start and end dates, once the macro is run, I’d like to insert a row and place these additional dates into this row. On the “after” tab, you’ll see that for titles 1 and 3, a new row has been inserted, the title in col A has been repeated in the new row and the dates that were once beyond period 5 have now been inserted into this new row – essentially wrapping the extra dates into the new row.

The Periods in row 1 and Title, Start Date and End Dates are not always in the same lettered column, so this is why I want to use the headers in rows 1 or 2 as needed to identify the columns to be moved. Would need to loop through upwards of several thousand rows.

Any help or guidance would be most appreciated!
Also posed question on mrexcel: http://www.mrexcel.com/forum/showthr...14#post2501014