Issue while invoking method to remove a data row

Hi All,

I am automating a process, where i have two excel sheets and i have to match the first one with the second one and remove the entries from the second one whenever there is a match. Basically, second one is the master sheet and the first one is the subset of second one. And at the end of the execution, i want the second sheet devoid of the entries of the first one. To do that, i did a for each inside a for each, applied an if condition and whenever there is a match, invoked the method to remove that row from the first second sheet. But i am getting an error as: “For Each Row: Collection was modified; enumeration operation might not execute”. Can you please help me out.



Already discussed many times in the forum. You should search first before asking :frowning:

e.g. here: