I have two excel sheets Sheet1 and Sheet2 shown below:
The output file has a new column “Sqty New” = Sqty - Aqty.
Here if the value of sheet1 matches with sheet2 the do subtraction otherwise leave as it is .
I tried using for each loops but it is saying "Sequence contains no elements "
Can anyone suggest the workflow to be used for the above mentioned situation.