Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy formula amongst files but create cross-link problem
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 ? ********************** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy formula amongst files but create cross-link problem
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" wrote in message ... 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 ? ********************** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy formula amongst files but create cross-link problem
Hi,Yes you right. I forget this .... Replace the file with blank field ....
Thanks indeed. "macropod" wrote: 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" wrote in message ... 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 ? ********************** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy paste, link problem | Excel Discussion (Misc queries) | |||
Copy / Link Textboxes between Files | Excel Programming | |||
Copy File Formulas between Files w/o the link | Excel Worksheet Functions | |||
Create a Macro to Copy a Worksheet, and link certain cells... | Excel Programming | |||
Link-to-cell copy problem | Links and Linking in Excel |