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?
Tom

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

Roy
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.


Ivan

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

Ivan,Bill & Tom -- thanks a lot