Results 1 to 4 of 4

how to retain a fetched value from another workbook that get's moved and/or renamed

Threaded View

  1. #1
    Registered User
    Join Date
    09-23-2019
    Location
    Isle of man
    MS-Off Ver
    16
    Posts
    11

    Question how to retain a fetched value from another workbook that get's moved and/or renamed

    Hi gang

    Still very new to learning excel, so this may be a very dumb question for most of you.

    Im working with two work books, located over a network on different computers.

    I'm currently using this formula in my "Book1" to pull data from "Book2"
    =VLOOKUP(A1,[Book2]Sheet1!$A$1:$B$10,2,FALSE)
    I could also use
    =INDEX([Book2]Sheet1!$B$1:$B$11,MATCH(A1,[Book2]Sheet1!$A$1:$A$11,0)) Suggested by jeffreybrown when I was having an Issue.

    But these link to the data. So if the data in Book2 changes, or the book itself gets moved or renamed/deleted. I'll lose the data in Book1.

    Is there a "pull the current data and Keep it permanently" formula ?
    Like a Ctrl+c then Ctrl+V but in a cell formula veriant

    Cheers
    Last edited by L.Storm; 09-25-2019 at 03:12 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro doesn't work when workbook is renamed
    By tandi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-23-2012, 01:13 PM
  2. Update macro path after workbooks moved, renamed
    By jfreeman5 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2011, 03:06 PM
  3. pivottables: renamed fields and renamed data
    By lalbatros in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-04-2007, 03:30 PM
  4. having renamed a workbook my password does not work
    By Lyndsayd in forum Excel General
    Replies: 1
    Last Post: 08-26-2005, 10:05 AM
  5. [SOLVED] Require Workbook to be renamed in order to Save It
    By Steve Klenner in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-13-2005, 04:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1