Hi Arkadi / K64,

Both codes work fine, Arkadi's code check all rows one by one, uses If conditions & copies them to appropriate sheets, whereas K64's code looks more simple & short and gets the work done through AutoFilter.

@K64 :

I've never used the Intersect function before, but wonder how it works. Can you brief me about it ?