ok i tested code and i had to make some changes. why wont it do the code following the test? i bet its right in front of me...
Sub DeviceCordLabels()
Dim MyCount As Integer
Dim DCL As Integer
Dim CriteriaA As String
Dim CriteriaB As String
Dim CriteriaC As String
Dim CriteriaD As String
DCL = 1
MyCount = Cells(ActiveSheet.Rows.Count, 1).End(xlUp).Row
For i = 6 To MyCount Step 1
Sheets("DEVICE LABELS").Select
CriteriaA = Left(Range("A" & i).Value, 3)
If CriteriaA = "PRX" Then
Range("A" & i & ":D" & i & "").Copy
Sheets("DEVICE CORD").Select
Range("A" & DCL).Select
ActiveSheet.Paste
DCL = DCL + 1
End If
Sheets("DEVICE LABELS").Select
CriteriaB = Left(Range("A" & i).Value, 2)
If CriteriaB = "PE" Then
Range("A" & i & ":D" & i & "").Copy
Sheets("DEVICE CORD").Select
Range("A" & DCL).Select
ActiveSheet.Paste
DCL = DCL + 1
End If
Sheets("DEVICE LABELS").Select
CriteriaC = Left(Range("A" & i).Value, 1)
test = IsNumeric(Mid(Range("A" & i).Value, 2, 1))
If CriteriaC = "M" And test = 1 Then 'both values could be true but it wont run code.
Range("A" & i & ":D" & i & "").Copy
Sheets("DEVICE CORD").Select
Range("A" & DCL).Select
ActiveSheet.Paste
DCL = DCL + 1
End If
Sheets("DEVICE LABELS").Select
CriteriaD = Left(Range("A" & i).Value, 2)
If CriteriaD = "PS" Then
Range("A" & i & ":D" & i & "").Copy
Sheets("DEVICE CORD").Select
Range("A" & DCL).Select
ActiveSheet.Paste
DCL = DCL + 1
End If
Next i
End Sub
Bookmarks