Copy functions from one file to another file

  • Thread starter Thread starter Elton Law
  • Start date Start date
E

Elton Law

Dear Expert,

Want to copy a function from one spreadsheet to another spreadsheet
(different file name).
I just want to copy a function (as follows) from Tolerence Checker.xls to
Tolerance Checker.xls (Different file name ... one is Tolerence and another
os Tolerance ....

From file Tolerence Checker.xls,
=IF(VLOOKUP(A2,'Ignore List'!A:B,1,FALSE)=A2, "YES", "NO")

After copying .... in Tolerance Checker.xls,
=IF(VLOOKUP(A2,'[Tolerence Checker.xls]Ignore List'!A:B,1,FALSE)=A2, "YES",
"NO")

The forumla becomes cross-link from Tolerence Checker which is unnecessary ...

How to copy so that this can be avoided please ?
Thanks
 
Select the cell with the formula you want to copy
Highlight the formula in *the formula bar*
Copy the formula then hit Escape
Navigate to the other file and paste the formula where you want it
 
Back
Top