I have a scenario where there are two excel sheets and for each row of both the sheets I need to store a value in a variable and perform some mathematical operation and store that value in the next sheet. How can I achieve this task using 2 for loops? I am attaching my workflow below.PS3_Final_Project.zip (36.5 KB)
So basically lets break down the issue here.
- You have 2 excel sheets with some numerical data in it.
- You need to add the numbers from 1st excel with numbers from 2nd excel.
- You need to save the final answer in a 3rd excel.
Is this correct?
I am just going through your workflow, just give me a min please.