Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy VLookup formula from one spreadsheet to another
I am by no means an excel guru, and I'm needing a little help. I have
numerous cells that are using the following Vlookup formula: VLOOKUP("Total Amount ("&LEFT($C4,4)&")",Report!$B$1:$E$1000,2,FALSE) ) The "Report" sheet will be present in all subsequent workbooks that I create. Whenever I copy and paste the formula to another workbook, Excel places the name of the file in the formula. I.E.: VLOOKUP("Total Amount ("&LEFT($C15,4)&")",'[Week 14.xls]Report'!$B$1:$E $1000,2,FALSE) How can I prevent it from doing this, or is there something that I can put in the vlookup to tell it to always use the current workbook? Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy VLookup formula from one spreadsheet to another
You should Copy the Formula to Notepad and then copy (from Notepad) to the
second sheet to prevent it referencing the sheet it originally came from. HTH " wrote: I am by no means an excel guru, and I'm needing a little help. I have numerous cells that are using the following Vlookup formula: VLOOKUP("Total Amount ("&LEFT($C4,4)&")",Report!$B$1:$E$1000,2,FALSE) ) The "Report" sheet will be present in all subsequent workbooks that I create. Whenever I copy and paste the formula to another workbook, Excel places the name of the file in the formula. I.E.: VLOOKUP("Total Amount ("&LEFT($C15,4)&")",'[Week 14.xls]Report'!$B$1:$E $1000,2,FALSE) How can I prevent it from doing this, or is there something that I can put in the vlookup to tell it to always use the current workbook? Thanks in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy VLookup formula from one spreadsheet to another
Copy the formula from the formula bar or if there are many, replace the
equals sign with something unique like find what = replace with ^=^ then copy over the text strings to the new workbook, then reverse the replace in both workbooks -- Regards, Peo Sjoblom wrote in message ups.com... I am by no means an excel guru, and I'm needing a little help. I have numerous cells that are using the following Vlookup formula: VLOOKUP("Total Amount ("&LEFT($C4,4)&")",Report!$B$1:$E$1000,2,FALSE) ) The "Report" sheet will be present in all subsequent workbooks that I create. Whenever I copy and paste the formula to another workbook, Excel places the name of the file in the formula. I.E.: VLOOKUP("Total Amount ("&LEFT($C15,4)&")",'[Week 14.xls]Report'!$B$1:$E $1000,2,FALSE) How can I prevent it from doing this, or is there something that I can put in the vlookup to tell it to always use the current workbook? Thanks in advance. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy VLookup formula from one spreadsheet to another
Thanks for the suggestions.
I have found that if you go into Edit....Links....Change Source to the current file, that this updates the formulas. I'd really like a way in the function to tell it to always use the current workbook, but I don't know if there is a way to do this or not. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy VLookup formula from one spreadsheet to another
On Saturday, 14 April 2007 at 00:42:08 UTC+8, wrote:
Thanks for the suggestions. I have found that if you go into Edit....Links....Change Source to the current file, that this updates the formulas. I'd really like a way in the function to tell it to always use the current workbook, but I don't know if there is a way to do this or not. Great thanks. Very helpful. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy a vlookup formula without changing the "table_array" p | Excel Worksheet Functions | |||
How do I copy spreadsheet data as shown to another spreadsheet? | Excel Discussion (Misc queries) | |||
In Excel I want to copy text from spreadsheet to spreadsheet | Excel Worksheet Functions | |||
new copy of spreadsheet using old spreadsheet info. | Excel Discussion (Misc queries) | |||
Copy VLOOKUP Formula | Excel Discussion (Misc queries) |