This is probably pretty easy for someone not guessing how to make it work: I am trying to find then move a block of rows if they contain "DPP" in column C using cut and paste. The rows would then be inserted above a row that contains "GA" in column C. The data is sorted alphabetically by column C.
I thought an IF statement something like the following would work, but it's not.
lastrow = Cells(Rows.Count, "c").End(xlUp).Row
For rwnum = lastrow To 1 Step -1
With Cells(rwnum, "C")
If .Value = "DPP" Then
If .Value = "GA" Then
Your help would be appreciated.