Copy functions from one file to another file

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
 
T

T. Valko

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy formula amongst files but create cross-link problem 2
New computer, how do i move outlook 365 ENTIRELY? 0
Excel - Wich Function should I use? 1
Avoiding redundant calculations 7
copy specific cells from sheets if the information is correct 3
Copy columns, but not hidden ones 3
Copy and paste slide from one presentation to another presentation gives an error 2
Comparing dates from VLOOKUP functions not working right 2

Top