Sub IF_LOOP()
For Each Cell In Range("A2:A10")
If Cell.Value = AAKAS Then
Cell.Offset(0, 1).Value = "POSITIVE"
ElseIf Cell.Value = PAWAN Then
Cell.Offset(0, 1).Value = "NEGETIVE"
Else
Cell.Offset(0, 1).Value = ""
End If
Next Cell
End Sub
function copyDataWithinWorkbook() { var sourceSheetName = "Dashbord"; // Replace with the name of the source sheet var target...
No comments:
Post a Comment
THANKS FOR YOUR SUPPORT