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) 