Hey everyone,
I'm using the loop below to check column R for specific values. What I'd also like to be able to do in this same loop is check column G for some of these same values using offset. Any suggestion on how to achieve this?
Dim dataIn, dataOut
last = Cells(Rows.Count, "R").End(xlUp).Row
dataIn = Range("R3:R" & last).Value2
dataOut = Range("AB3:AB" & last).Value2
For i = 1 To UBound(dataIn)
If dataIn(i, 1) <> "" Then dataOut(i, 1) = "MISC EXPENSE"
If dataIn(i, 1) Like "*12X12X12*" Then dataOut(i, 1) = "OFFICE EXPENSE"
If dataIn(i, 1) Like "*12X12X10*" Then dataOut(i, 1) = "OFFICE EXPENSE"
If dataIn(i, 1) Like "*17.5X12X3*" Then dataOut(i, 1) = "OFFICE EXPENSE"
Bookmarks