Good evening peers,
I am trying to figure out a logical way of deleting the highlighted rows in RED on the attached example workbook.
the data is variable so it can change location and im trying to determine what logical approach i would take to delete the unncessary rows generated.
I have tried with the below code and my logic is off and i could do putting this out there getting advice from my peers!
myVal = Range("Z1").Value
LastRow = Cells(Rows.count, "K").End(xlUp).Row
Application.ScreenUpdating = False
With Range("I6:I" & LastRow)
.Formula = "=IF(I6=" & myVal & ",1,"""")"
.Value = .Value
On Error Resume Next
Any advice would be appreciated.