Copy across files

emlu3

New Member
Joined
Dec 27, 2005
Messages
1
I have a page of formulas on a worksheet in excel. I want to a create a copy of the formulas across to another worksheet in another excel file. However when I do this, the address of the old worksheet is copied as well. So the new sheet does the calculations of the values in the old file instead of the new one. Can anyone help me? Thanks

Emily
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

nbrcrunch

Well-known Member
Joined
Jan 1, 2003
Messages
2,062
have you tried Paste-Special > Formulas?

(oh yeah, welcome to the board! :) )
 

Watch MrExcel Video

Forum statistics

Threads
1,119,128
Messages
5,576,251
Members
412,709
Latest member
Rishu
Top