VBA To Insert Row When A New Value Is Detected

**Simon.Ward** · 02-18-2013, 06:07 AM

Hi,

Please see the attached spreadsheet.

I need a vba code to detect when then numbers in Column C change and to insert a new row upon this change detection.

So for an example using the attached (Sheet named "Pre VBA"), i need it to detect when the cell value changes from 23 to 5023 and to insert a new row in between them, and again for 5023 to 31 and so on.

Also in this new row i want it to copy the information up from the row below but only the information in columns C and D.

So again for an example using the attached (Sheet named "Post VBA"), this is how i want the finished layout after the VBA has been run, noting that Rows 6, 9, 12, 17 and 20 are the new rows which the VBA code has inserted and copied the data into?

Let me know what you think

Many Thanks

Simon

**Simon.Ward** · 02-18-2013, 06:45 AM

I now have this code working fine which inserts the new row when the sequence in Column C changes:

Please Login or Register  to view this content.

BUT - i now need to copy the data in Column C & D from the row below into the new row column C & D

Thanks

SImon

**arlu1201** · 02-18-2013, 06:49 AM

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.

**Simon.Ward** · 02-18-2013, 06:51 AM

Originally Posted by arlu1201

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.

Sorry, thanks for amending, will remember that for future posts