Emoncada
11-13-2012, 10:25 AM
I am trying to do the following.
I am copying data from one sheet to another and would like if in column B data starts with "DC" then Column C would be "Desktop" else "Laptop"
I tried the following
If Left(Range("B7:B400").Value, 2) = "DC" Then
Range("B7:B400").Offset(0, 1).Value = "Desktop"
Else
Range("B7:B400").Offset(0, 1).Value = "Laptop"
End If
But got an error.
Any help would be great.
I am copying data from one sheet to another and would like if in column B data starts with "DC" then Column C would be "Desktop" else "Laptop"
I tried the following
If Left(Range("B7:B400").Value, 2) = "DC" Then
Range("B7:B400").Offset(0, 1).Value = "Desktop"
Else
Range("B7:B400").Offset(0, 1).Value = "Laptop"
End If
But got an error.
Any help would be great.