Copy Worksheet from one Workbook to another Workbook

A

Autumn Dreams

How do I copy a Worksheet from one Workbook to another Workbook without
referencing the orginal Workbook in the formulas? I would like to copy the
entire Worksheet without any reference to the original Workbook.
 
E

excelent

open both workbooks
rightclick on the sheettab u want to copy
select move or copy
checkout the copy box
select destination in dropdown menu
ok
 
A

Autumn Dreams

Thank you. This will work for new workbooks. However how do I copy it to an
existing workbook. I found this answer on the site, however when I tried it
to copy to an existing workbook, the only option in the dropdown memu was
"new book" and the destination of the original workbook.
 
D

Dave Peterson

You'll only see workbooks that are open in that session.

So open that other workbook first, and you'll be fine.
 
J

John

I am able to do that part...... But what if I want to only copy the formulas
of everything in the workbook. I have a workbook with 50 worksheets in it
for the previous year. Now, I want to create one for the new year, but do
not want to delete everything and start over from scratch. 50 worksheets is
a lot of editing.

So, is there a way to create a new workbook for next year that contain all
of the information from the other workbook that would contain only the
formulas?
 
G

Gord Dibben

Right-click on a sheet tab in your book and "select all sheets"

Select all cells in the active sheet.

F5>Special>Constants.

De-select "Text" so's you keep tiles etc. then OK

Edit>Clear>Contents

Formulas and text cells will remain.

Right-click on the sheet tab and "ungroup sheets".

File>SaveAs...................new year


Gord Dibben MS Excel MVP
 
Top