I have to do an activity with 3 excel documents. I show u the structure:
First Excel Sheet:
Second Excel Sheet:
Third Excel Sheet:
And i want to create an output document like this, where i get ID, Account Number, Description, Area Code, B.Balance, B.Due, Payment, Total (from secund sheet) and Value (from first sheet) and i search negative or positive differencies (With the subtraction of “Value” and “Total”).
I was thinking in use Invoke Code after of extract data from excel with read range but i dont know how to iterate through files and columns and get that data.