How can I optimize my bot. Its taking forever using For Each.
sample.xlsx (96.5 KB)
On the attached excel, data1 sheet I’m supposed to read it and sumif using name and item sum the amount, as output “Sumif” sheet. Here is the first delay. over an hour.
Second bit, I’m supposed to loop through each name and fill in the summed ammount and the person who paid as per “Anant sheet”. Anant represents the first person name trimmed.
In both above I’m using for each to loop through.
Could there be a much faster approach using invoke code.