I would like to extract Column B and Column C’s value if Column D has the same value as the next row’s Column D. After extracting those values into a new Excel workbook, they will be used to create a HTML table and send to Email, the newly created Excel workbook will be cleared and the process will be repeated until there is no value to be read in the Excel.
There should be 4 person in total in the table.
Every time I run the process, there will be an error that says "Collection was modified; enumeration operation might not execute. ". The table has successfully been created but there will always be a missing person. I am fairly new to RPA so I would very much appreciate if someone would assist me on this.
Task.zip (33.2 KB)