ExcelBanter - How do you copy a sheet (with Formulas) to another Workbook?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do you copy a sheet (with Formulas) to another Workbook? (https://www.excelbanter.com/excel-discussion-misc-queries/22056-how-do-you-copy-sheet-formulas-another-workbook.html)

markpecz

How do you copy a sheet (with Formulas) to another Workbook?

I have two separate files.
I want to copy one of the files into a new €œSheet€ in the other file.
However, when I do that I lose all of the formulas.
All that copies over are the calculated values.
Is there a way to copy over all of the formulas just like in the original
file?

Pank Mehta

Markpecz,

Use the Paste Special with Formulas option.

HTH

"markpecz" wrote:

I have two separate files.
I want to copy one of the files into a new €œSheet€ in the other file.
However, when I do that I lose all of the formulas.
All that copies over are the calculated values.
Is there a way to copy over all of the formulas just like in the original
file?

All times are GMT +1. The time now is 02:31 AM.