Quick Vba question to copy from the last row to the second row of the data

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

Please Login or Register  to view this content.