Hello,

I'm looking for a macro code that help me copy data from the last row and paste special number only to the second row. For example. I have data in column W7:W18. I want macro to copy from W8:W18 and paste special. Hope this should not be complicated.

Thanks