Need MACRO help on inserting new rows when the value change.

[wantaku11]

Good Day everyone

I need help on how to insert row when ever the list inside column change value. Example;

Column A

21341
21341
21341
21288
21288
22344
22344


When the macro read 21288 it will insert new row above it. Then 22344 it will insert new row above it.

that's how it is..

Please guide me how to write the macro script.

thank you

[benishiryo]

hi wantaku11, assuming data starts from A1, try:

Please Login or Register  to view this content.

hope that helps & wishing you a merry Christmas eve~

[jindon]

Different method, no loop

Please Login or Register  to view this content.

[Winon]

@ jindon,

Very nice!

I am trying to tweak your formula to cater for a header in Column A, but I cannot get the Formula right.

It still shoes the header, but the Empty lines do not get inserted in the correct Row between the diffirent values.

[jindon]

If header

Please Login or Register  to view this content.

[Winon]

@ jindon,

Very good, thank you!

I must have hit a blank, because I could not spot this obvious approach.

Maybe in future, I should just retire for a while when I am feeling so tired, as I did this morning.

wantaku11 will surely like this improvement.