Copying an unknown number of cells in Sheet1 to Sheet2 starting from "F2"

Hi. Could anyone please kindly help.

Row 1 in my worksheet contains the headers and data starts from Row 2.

In every column starting from Column C of Sheet1, I have a time series. The number of columns is unknown (depends on the kind of data).

I want to copy everything starting from cell C2 to "cell(last row, last column)", and paste this selection into Sheet2, starting from Cell F2.

Thanks in advance for your help. Cheers!

You can try with this macro:

Please Login or Register  to view this content.

I hope it's what you need.

Regards,
Antonio

Brilliant! Thank you. It works perfectly!

What if, rather than just pasting, I want to "paste special -- values"?

The source worksheet that I copied from has formulae but I only want the values to be copied to the destination worksheet.

Thank you.