| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy functions from one file to another file
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy functions from one file to another file
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 -- Biff Microsoft Excel MVP "Elton Law" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy a excel file into a InDesign file correctly? | Excel Discussion (Misc queries) | |||
| copy the same raws of all sheets from about a 100 file to a new sheet of a book and save the file | Setting up and Configuration of Excel | |||
| How do I copy a file and attach a date to the name of the file | Excel Discussion (Misc queries) | |||
| copy excell file to a CSV file and than to Notepad | Excel Discussion (Misc queries) | |||
| copy/paste from one file to another without file name reference | Excel Discussion (Misc queries) | |||
![Elton Law[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
