Insert row on value change

[anrichards22]

I can insert a row where the value in column A changes, however I only want to insert the row where the value in column A changes from xx1 to xxx2.

Where "xxx" can be any string



Col A

A1
A1
A1
A2
A2
B1
B1
B1
C2
C2
C1
C1
C2


I want to be able to insert a row between A1 and A2, B1 and B2 but NOT between A2 and B1, B2 and C1 etc etc

Any ideas?

I have attached a small sample.

Thanks.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[MickG]

Try this:-
NB:- At the moment, this will only work on Data with 2 character strings

Please Login or Register  to view this content.

Regards Mick

[MickG]

This code is better, it caters for instances where there are multiple rows one after the other that need a blank row inserting.

Please Login or Register  to view this content.

Regards Mick

[anrichards22]

Thanks John H and MickG I will give your code a try.

[anrichards22]

Thanks again John H & Mick G, your code does the job.

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.

[yorelsemaj]

Hi Mick G.

I have a similar issue that your code can resolve. The diffference however is that I want an Enitre Row to be inserted as there will be data in other columns (B, C, D, ....).

What change should be made in insert rows across multiple colums?

Thanks
Yorelsemaj

[MickG]

Add "Entirerow", in code, where show below:-

Please Login or Register  to view this content.