+ Reply to Thread
Results 1 to 4 of 4

Linking to a value from another workbook?

  1. #1
    Forum Contributor
    Join Date
    06-18-2010
    Location
    London
    MS-Off Ver
    Excel 365
    Posts
    132

    Question Linking to a value from another workbook?

    Hi,

    Is there anyway in which I can simply linked to/import the value(s) from a specific cell in a different workbook?

    Thanks!

    Z
    Last edited by zudecke; 11-09-2017 at 07:04 AM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,434

    Re: Linking to a value from another workbook?

    Same way you would link to a cell in a worksheet in the same workbook. Type an equals sign ( = ) and then navigate to the other workbook, select the sheet and the cell within it. Press Enter to complete the process.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor
    Join Date
    06-18-2010
    Location
    London
    MS-Off Ver
    Excel 365
    Posts
    132

    Re: Linking to a value from another workbook?

    Thank you so much! Rep not working, but I'll keep trying.

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,434

    Re: Linking to a value from another workbook?

    You're welcome. Thanks for the rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Linking from one Workbook to another Workbook - Changing Links is Way too slow!
    By The Exceller in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-25-2016, 04:06 PM
  2. Replies: 1
    Last Post: 09-13-2016, 04:07 PM
  3. Linking One Workbook with Multiple Tabs to Master Workbook Formula
    By Scholzie220 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-27-2015, 09:13 AM
  4. Linking and Update automatically data from workbook to another workbook
    By MzExec2U in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-03-2014, 01:09 PM
  5. Replies: 2
    Last Post: 05-31-2013, 08:45 AM
  6. Replies: 2
    Last Post: 03-07-2013, 05:18 AM
  7. Linking Master Workbook & subordinate workbook
    By Lucky_guy2000 in forum Excel General
    Replies: 1
    Last Post: 07-14-2006, 05:45 PM

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