Copy formula amongst files but create cross-link problem

[Elton Law]

Hi all,
Have posted this before in Excel functions.
But look like that cannot make it.
Can VB script (run marco) eliminate this problem please ?
**********************
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
is 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 ?
**********************

 

[macropod]

Hi Elton Law,

You can either copy the formula from the formula bar or, having copied the cells, use Find/Replace to remove the unwanted
"[Tolerence Checker.xls]" workbook referfences.

 

[Elton Law]

Hi,Yes you right. I forget this .... Replace the file with blank field ....
Thanks indeed.

Hi Elton Law,

You can either copy the formula from the formula bar or, having copied the cells, use Find/Replace to remove the unwanted
"[Tolerence Checker.xls]" workbook referfences.

--
Cheers
macropod
[Microsoft MVP - Word]

Hi all,
Have posted this before in Excel functions.
But look like that cannot make it.
Can VB script (run marco) eliminate this problem please ?
**********************
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
is 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 ?
**********************