Results 1 to 4 of 4

Reference another workbook in a formula

Threaded View

  1. #1
    Registered User
    Join Date
    11-11-2009
    Location
    Calgary, Canada
    MS-Off Ver
    Excel 2003
    Posts
    2

    Reference another workbook in a formula

    I am having trouble inserting a cell reference into a formula. I have a spreadseet that uses data from another workbook. The workbook name changes monthly, so i'd like to be able to place the workbook name in a cell and have the formulas in the spreadsheet use that cell to get the name of the workbook to get the data from. So:

    if, for eg, the formula in my spreadsheet is ='[test data file.xlsx]Sheet1'!$B$4+'[test data file.xlsx]Sheet1'!$B$6

    I would like to be able to enter test dta file.xlsx into cell A2 of my spreadsheet and replace a reference to A2 into the formulas.
    I've tried several ways, but can't seem to get it to work.
    Any suggestions?
    Last edited by dlmeyers; 11-11-2009 at 04:01 PM.

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