+ Reply to Thread
Results 1 to 2 of 2

Include cell value in folder path for a linked file

  1. #1
    Registered User
    Join Date
    12-07-2010
    Location
    Sweden
    MS-Off Ver
    Excel 2010
    Posts
    15

    Question Include cell value in folder path for a linked file

    Hello all,

    I have a master file with several states and for each state, I have an Excel-file.
    My master file looks like below:

    A B C D E
    1 VALUE1 VALUE2 VALUE3 etc
    2 CA ='[CA.xlsx]Sheet1'!$B$3
    3 WI ='[WI.xlsx]Sheet1'!$B$3
    4 FL ='[=B4.xlsx]Sheet1'!$B$3




    The value 1 and 2 are linked from each state file. I would like to fetch the value in ca.xls in cell B3 and place it under value 1 for CA, wi.xlsx B3 to value 1 WI, etc.

    Is there a way to use a cellreference in the cross reference, see above in C4. This way it would be much faster than creating individual ones..

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Include cell value in folder path for a linked file

    Use INDIRECT.EXT

    read here
    http://www.ashishmathur.com/tag/indirect-ext/
    Life's a spreadsheet, Excel!
    Say thanks, Click *

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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