Copy Specific Columns from a Filtered Range

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 ?

Originally Posted by Saarang84

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 ?

Intersect returns a range composed of only those cells in common between the intersected ranges. So intersect(range("A:A"), range("1:1")) = range("A1")