I hope someone can help, I have data which I have sorted using the recorder. I now want the recording to loop and to continue until the last cell of the data.
ActiveCell.FormulaR1C1 = "=IF(OR(RC[4]=""down"",RC[4]=""),"""",MID(R2C3,9,7))"
Range("B2").Select
ActiveCell.FormulaR1C1 = "=IF(OR(RC[3]=""down"",RC[3]="","""",MID(R2C3,20,20))"
Range("A2:B2").Select
Range("A2:B2").AutoFill Destination:=Range("A2:B2" & LastRow)
I would like the macro to loop when column E in two consecutive rows e.g E4 and E5 are equal to "down" then it should repeat both if statements above. It should loop by offsetting : down 1 row and back 4 columns for the first if statement and then down 1 row and back 3 columns
ActiveCell.FormulaR1C1 = "=IF(OR(RC[4]=""down"",RC[4]=""),"""",MID(R2C3,9,7))"
Range("B2").Select
ActiveCell.FormulaR1C1 = "=IF(OR(RC[3]=""down"",RC[3]="","""",MID(R2C3,20,20))"
Range("A2:B2").Select
Range("A2:B2").AutoFill Destination:=Range("A2:B2" & LastRow)
I would like the macro to loop when column E in two consecutive rows e.g E4 and E5 are equal to "down" then it should repeat both if statements above. It should loop by offsetting : down 1 row and back 4 columns for the first if statement and then down 1 row and back 3 columns
