Thread: Copy VLookup formula from one spreadsheet to another
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
vivian.hsieh riccachika vivian.hsieh riccachika is offline
external usenet poster
  
Posts: 1
Default 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 With QuoteReply With Quote