I am trying to copy and paste a block of cells from one spreadsheet to
another. The original file is formulas and the destination cells must be the
same formula.

any suggestions on how to add this into a macro?