+ Reply to Thread
Results 1 to 1 of 1

Linking value in external worksheet - filename varies depending on values in cells

  1. #1
    Registered User
    Join Date
    07-03-2013
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    19

    Linking value in external worksheet - filename varies depending on values in cells

    I'm trying to extract a value from a cell in a file (J:\Offshore Wind Generation\Offshore Wind Generation File Store\GGOWL\Availability Calculations\SWP Monthly Availability\14.01\[phase 2 avail breakdown 01.2014.xls]GG Bespoke Availability'!$D$115:$F$115), and the month/year changes depending on the the value in other cells. for example, in the file name here, I have data for January 2014, and the values 01, 14 and 2014 are created elsewhere (J6 (month, I6 year and H6 respectively). When the user wants to see February 2014, the values will change to 02,14 and 2014, and the filename should then change to
    J:\Offshore Wind Generation\Offshore Wind Generation File Store\GGOWL\Availability Calculations\SWP Monthly Availability\14.02\[phase 2 avail breakdown 02.2014.xls]GG Bespoke Availability'!$D$115:$F$115.
    When I have the file open in another session, it links fine, but I need to create a dynamic cell reference, and I can't seem to get it done properly.

    So the filename should be:
    J:\Offshore Wind Generation\Offshore Wind Generation File Store\GGOWL\Availability Calculations\SWP Monthly Availability\I6.J6\[phase 2 avail breakdown J6.H6.xls]GG Bespoke Availability'!$D$115:$F$115.

    Can anyone help?

    Thanks!!!
    Last edited by magnus.blomquist; 02-24-2014 at 12:00 PM. Reason: clarification

+ 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. Help with linking to external books referencing cells
    By rtdownes in forum Excel General
    Replies: 1
    Last Post: 02-23-2012, 07:11 PM
  2. linking to external books with formula referencing cells
    By rtdownes in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-23-2012, 02:41 PM
  3. Excel 2003: Creating a table that varies depending on which check-boxes are ticked.
    By mackinlay in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-09-2008, 08:32 AM
  4. External linking to an entire worksheet
    By JoelBU in forum Excel General
    Replies: 6
    Last Post: 10-04-2007, 12:44 PM
  5. XP linking to external cells bug?
    By JethroUK© in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 08-19-2005, 07:05 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