I have an excel sheet named as “ITBricks”. In that I have 2 sheets named as “data” and “test”
- from the sheet “data” I want to read column G
- from the sheet “test” I want to read column “Expected”
- I want to compare both the columns and if both values are same I want to update in the sheet “data” column “H” as Pass or Fail.
Please help me to do this