+ Reply to Thread
Results 1 to 2 of 2

Concatenating cells to produce a cell ref from another excel file

  1. #1
    ItsMeAgain
    Guest

    Concatenating cells to produce a cell ref from another excel file

    Can anyone tell me how I might combine to cells to generate a thrird cell
    content which calls data from an external reference e.g. I am in wb1.xls and
    I have two cells a1 and b1. c1 = a1&b1. a1 = the file name of the external
    source, wb2.xls and b1 = the cell reference in wb2. This is so that i can
    keep cell rfernces constant but with variable file names. the problem I have
    is that I need to make this concatenated cell, c1 operate as =a1+b2 but I
    only seem to be able to intorduce the = sign as text.


  2. #2
    JE McGimpsey
    Guest

    Re: Concatenating cells to produce a cell ref from another excel file

    If your external reference file is open, then try

    =INDIRECT("[" & A1 & "]" & A2)

    Where

    A1: wb2.xls
    A2: Sheet1!A1

    INDIRECT() doesn't work on closed files.

    In article <00B02C6B-ABA9-42EC-834B-1915ED6426C5@microsoft.com>,
    "ItsMeAgain" <ItsMeAgain@discussions.microsoft.com> wrote:

    > Can anyone tell me how I might combine to cells to generate a thrird cell
    > content which calls data from an external reference e.g. I am in wb1.xls and
    > I have two cells a1 and b1. c1 = a1&b1. a1 = the file name of the external
    > source, wb2.xls and b1 = the cell reference in wb2. This is so that i can
    > keep cell rfernces constant but with variable file names. the problem I have
    > is that I need to make this concatenated cell, c1 operate as =a1+b2 but I
    > only seem to be able to intorduce the = sign as text.


+ 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