I have to compare the value in sheet 1 and sheet 4…
example:
in sheet 1 i have the value check whether C column value is equals to sheet 4 C column.
if it is same i have to send mail or i have to perform different action…
Take a Excel application scope and take read range activity and here take assignment variable to compare the value. Take a for each row. Inside this take Excel application scope and take read range activity. Take a assignment variable. In this For each row compare the value.