I need to copy a range (c1:n1) every 11th row in a long spreadsheet. The
data is numerical and will be used in a formula that will reference this
data. The rows to paste into start with C11:N11 and run through C787:N787.

I also need to a macro to copy a formula in the same manner and size.

HELP?