I am trying to select rows where country_code = US and dl_state is blank then move them to a new worksheet (cut and paste).
Attached is dummy data. I have the below code that works to delete the rows when dl_state is populate with something but nothing works for blank(its blank no null).
Dim startrow As Long
'MODIFY YOUR START ROW HERE
startrow = 1
Do While ActiveCell.Value <> ""
If Cells(startrow, 23).Value = "US" And Cells(startrow, 25).Value = " " Then
'Don't Modify Start Row here because the rows just moved up
startrow = startrow + 1
I am open to any suggestions to get this to work. Thanks.