I don't know as how to do the if condition
As need to check every cell value in one
As need to check every cell value in one
VBA Code:
If ActiveSheet.Range("a2").Value <> "Skill Group Name" Then
If ActiveSheet.Range("b2").Value <> "Date" Then
If ActiveSheet.Range("C2").Value <> "Avg Speed of Answer" Then
If ActiveSheet.Range("D2").Value <> "Avg Abandon Time" Then
If ActiveSheet.Range("E2").Value <> "Handled" Then
If ActiveSheet.Range("F2").Value <> "Avg Handle Time" Then
If ActiveSheet.Range("G2").Value <> "Avg Wrap Time" Then
If ActiveSheet.Range("H2").Value <> "Abandon" Then
If ActiveSheet.Range("I2").Value <> "Longest Queued" Then
If ActiveSheet.Range("J2").Value <> "Dequeued" Then
If ActiveSheet.Range("K2").Value <> "%Handle Time" Then
If ActiveSheet.Range("L2").Value <> "%Answer" Then
If ActiveSheet.Range("M2").Value <> "Max Queued" Then
If ActiveSheet.Range("N2").Value <> "Handle Time" Then
MsgBox "Check Historical Raw file" & vbNewLine & "Header MisMatch"
End If
End If
End If
End If
End If
End If
End If
End If
End If
End If
End If
End If
End If
End If
End Sub