Copy formula amongst files but create cross-link problem

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

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 ?
**********************
 
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.
 
Hi,Yes you right. I forget this .... Replace the file with blank field ....
Thanks indeed.

macropod said:
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]


Elton Law said:
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 ?
**********************
Click to expand...
Click to expand...
 
Back
Top