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