+ Reply to Thread
Results 1 to 2 of 2

Formulas containing links to other Excel files

  1. #1
    Andrew Mackenzie
    Guest

    Formulas containing links to other Excel files

    I have a spreadsheet that I update monthly. A column of cells contains a
    formula that links to a previous spreadsheet something like this:

    =vlookup(a1,'[OctoberFile.xls]Sheet1'!$A$1:$K$100,4,false)

    If I put text in cell B1 "OctoberFile" I would like the [OctoberFile.xls]
    part of the formula to change if I change the content of cell B1 to
    NovemberFile so that it links to another file called NovemberFile.xls.

    Not sure if I have explained this very well does does anyone have any ideas
    without using code?

    Thanks,

    Andrew



  2. #2
    Anne Troy
    Guest

    Re: Formulas containing links to other Excel files

    You would normally use the INDIRECT function, but it sucks with external
    files, so code is your best bet in this circumstance (I think).
    http://www.officearticles.com/excel/...soft_excel.htm

    ************
    Anne Troy
    VBA Project Manager
    www.OfficeArticles.com

    "Andrew Mackenzie" <a_d_mackenzie@hotmail.com> wrote in message
    news:%236U71a56FHA.444@TK2MSFTNGP11.phx.gbl...
    >I have a spreadsheet that I update monthly. A column of cells contains a
    > formula that links to a previous spreadsheet something like this:
    >
    > =vlookup(a1,'[OctoberFile.xls]Sheet1'!$A$1:$K$100,4,false)
    >
    > If I put text in cell B1 "OctoberFile" I would like the [OctoberFile.xls]
    > part of the formula to change if I change the content of cell B1 to
    > NovemberFile so that it links to another file called NovemberFile.xls.
    >
    > Not sure if I have explained this very well does does anyone have any
    > ideas
    > without using code?
    >
    > Thanks,
    >
    > Andrew
    >
    >




+ 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