scorpio3st
New Member
- Joined
- Sep 7, 2021
- Messages
- 22
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
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
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