I have 1 excel file with 3 sheets in it. Im only using 2 of them in my assignment.
I want to write range a cell in sheet1 IF the column1 value is the SAME as in sheet 2.
sheet1 - column1 - value: 222
sheet2 - column1 - value: 222
If both sheet values are EQUAL then write range in sheet1 "it is equal"
And continue doing this for each item