Macro - enter row once data does not match

[ffionnah]

Hi all,
Is there a way that I can make a macro to enter a row once 2 cells no longer match?

Let's say there is data in columns "A" to "Z". Once the data no longer matches in Column "L", I would like a row added in between.

Thank you!

 

[MUKESHY12390]

can explain your criteria ... here you comparing column "L" with which column?

 

[Peter_SSs]

Give this a try in a copy of your workbook to see if it does what you want. If not, more clarification please.

Sub Insert_Row()
  Dim r As Long
  
  Application.ScreenUpdating = False
  For r = Range("L" & Rows.Count).End(xlUp).Row To 3 Step -1
    If Range("L" & r).Value <> Range("L" & r - 1).Value Then Rows(r).Insert
  Next r
  Application.ScreenUpdating = True
End Sub