MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copying Formulas

Posted by Roy Garrad on February 17, 2000 10:41 AM

We are trying to copy formulas from one Excel 97 SR2
workbook to another.

Source formula is =IF(G8=0,0,ROUND(G8*COST!E9*0.5,0))

The formula as copied is =IF(G8=0,0,ROUND(G8*[BLANK.XLS]COST!E9*0.5,0))

What are we doing wrong???

Appreciate any help Thanks

Posted by Tom Morales on February 17, 2000 11:37 AM

Roy - I don't think you're doing anything wrong. "Blank.xls" is presumably the file name of the source workbook where the sheet named "copy" is located. Is there a problem? Do you want a different cell E9 referenced?

Posted by bill roberts on February 17, 2000 12:17 PM

Instead of CUT and PASTE, try:

1) Hit F2
2) Press SHIFT, Hit HOME, Release SHIFT
3) Press CTRL, Hit C, Release CTRL

On new sheet (and EXACT REF used for copy):

4) Press CTRL, Hit P, Release CTRL

This method is perhaps bulky but it worsks.

Posted by Ivan Moala on February 17, 2000 2:52 PM

As Tom said you aren't really doing anything wrong
it's just that your original ref formula is linked
to the workbook that it was created to.
To ref the new workbook;
Click "Edit"
Select "Links..."
Click "Change source"
Then select your new workbook ie. the Activeworkbook
you are in.


Posted by Roy Garrad on February 18, 2000 7:12 AM

Ivan,Bill & Tom -- thanks a lot