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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
Use Macro to Copy Formula from one Workbook to another 4
Merge Multiple workbook sheets into one workbook 0
Macro to Copy Sheets to new workbook 18
HELP - A formula or sheet you want to move or copy contains the name .... 0
Copy same formula to all worksheets in a workbook 1
VBA Copy values only onto new workbook 1
Copy formulas to another workbook 4

Back
Top