Sunday, August 29, 2021

MULTIPLE IF CONDION BY VBA

 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


No comments:

Post a Comment

THANKS FOR YOUR SUPPORT

Data copy paste on two another sheet with add row in google sheet by script

 function copyDataWithinWorkbook() {   var sourceSheetName = "Dashbord"; // Replace with the name of the source sheet   var target...