1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL.MI

  • Copy VLookup formula from one spreadsheet to another

    From vivian.hsieh riccachika@21:1/5 to tcla...@cox.net on Mon May 10 07:58:04 2021
    On Saturday, 14 April 2007 at 00:42:08 UTC+8, tcla...@cox.net 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.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)