+ Reply to Thread
Results 1 to 2 of 2

External Workbook Link with Dynamic Cell Reference

  1. #1
    Registered User
    Join Date
    04-15-2013
    Location
    Arkansas
    MS-Off Ver
    Excel 2007
    Posts
    12

    External Workbook Link with Dynamic Cell Reference

    I currently have a file that is linked to an external workbook that is referencing a certain cell from a certain tab. The below is what Column A & B look like right now. What I'm wanting to know is is there a way to have the formula in Column B automatically reference the name in Column A (which is the tab name in the external workbook) instead of having to manually change the formula when the value in Column A changes?
    In other words, I want everything in the external reference formula to remain the same except have the person's name change dynamically...

    Thanks in advance for any help!!! : )




    Mary ='X:\Anderson Corporation\Employees\[Work Hours]Mary'!$F$42
    Joe ='X:\Anderson Corporation\Employees\[Work Hours]Joe'!$F$42
    Frank ='X:\Anderson Corporation\Employees\[Work Hours]Frank'!$F$42
    Michelle ='X:\Anderson Corporation\Employees\[Work Hours]Michelle'!$F$42
    Sam ='X:\Anderson Corporation\Employees\[Work Hours]Sam'!$F$42

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,758

    Re: External Workbook Link with Dynamic Cell Reference

    See attached for example of using Indirect.
    Attached Files Attached Files
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Replies: 0
    Last Post: 09-23-2013, 05:59 PM
  2. External workbook - reference with single link?
    By djarcadian in forum Excel General
    Replies: 2
    Last Post: 05-17-2013, 02:13 AM
  3. External Workbook Link with Dynamic Name
    By AdamParker in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-13-2009, 01:26 PM
  4. [SOLVED] Dynamic External Workbook reference
    By Co-op Bank in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-16-2005, 07:10 PM
  5. dynamic external cell reference
    By bg.itdept in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-19-2005, 12:06 AM

Tags for this Thread

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