Indirect reference to external workbooks
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Indirect reference to external workbooks

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    bellsouth
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have several workbooks with exactly the same format but different data. I want to extract a porton of the data (always the same tab and cell address) from each workbook. Anyone know how to write a formula that does this? I tried populating a column with the workbook names and then concatenating that with text within an Indirect formula, but only get volatile results. Does not help to try an array formula, either.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Posts
    363
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The indirect function does what you want but it only works within a workbook, not with links. What you might wanna try is create sheets that to the external workbook within the workbook and use indirect to formula to these worksheets. If you need further details or example let me know.

    It's never too late to learn something new.

    Ricky

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-11 15:54, Ricky Morris wrote:
    The indirect function does what you want but it only works within a workbook, not with links. What you might wanna try is create sheets that to the external workbook within the workbook and use indirect to formula to these worksheets. If you need further details or example let me know.

    I'd go with this idea, try to link directly to the book yur working on.

    BUT! INDIRECT() WILL work if the other book is open, the atnerntive is to open the book via a macro from the book your working on.

    Ricky, thought I'd mention, it's ALWAYS too late to learn something new if you've past the deadline you'd said you'd do it by
    "Have a good time......all the time"
    Ian Mac

  4. #4
    New Member
    Join Date
    Apr 2002
    Location
    bellsouth
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com