Hi All,
i am really new to this VBA and i seek for your help on the following:
Requirement:
1.Range O3:O1995 , S3:S1995 , and W3:W1995 copy and paste as value to C3:C1995
2.Range P3:P1995 , T3:T1995 , and X3:X1995 copy and paste as value to F3:F1995
3.Unable to skip the blank as All these range are with formula. i only need to copy those with data only. (tried to use lens but it didn't work)
4.when copy and paste these range , i dont want all these to override the data. it will paste as the next blank rows at range C3 and F3
Appreciate your help on the following.
Thank you