Need to copy specific columns, but only rows that in column "L" has no value

[scorpio3st]

Hi Team,

Please can you help me to create a VBA for copy data from WS named "Sheet1" in columns R-Y, but only copy rows that have some value in column "L" (if blank not copy) - paste it to WS named "Archive" to columns AF-AM

A note: in column "L" there is a formula for counting and adding value to the last number that is duplicated in the sheet: (=IF(K2<>K3;COUNTIF($K$2:K2;K2);"")

It will help me a lot if this can be resolved
Thanks a lot in advance

 

[SpillerBD]

You want to use the Advanced Filter, using the Copy to new location option.

 

[scorpio3st]

Hi SpillerBD,

I really need VBA.
Thanks.

 

[SpillerBD]

Record the Advanced Filter and modify.