+ Reply to Thread
Results 1 to 2 of 2

file name in a cell to use it as reference for formulas

  1. #1
    Registered User
    Join Date
    07-19-2007
    Posts
    2

    file name in a cell to use it as reference for formulas

    I really need help with this one,
    I have two books, the first one references the second one in many cells. The second one can change its name, so I should change all the formulas in my
    first book to reference the second one correctly. As this happens every month. I thought if I could store in one cell or wherever the name of the second book and reference all the formulas to that cell, in this case when the book name changes I only have to change one cell. I tried to do this but it doesn't work. Any ideas??? when I wrote the formula that references the cell with the book name, it tries to open that book.

    Is is possible to do this in other ways. It is impossible for me to change all the cell references every month as they are thouthands.

    tHE ONLY RESTRICION IS NOT TO USE MACROS.

    Help is appreciated,
    Thanks,
    Cybersandokan

  2. #2
    Forum Contributor EdMac's Avatar
    Join Date
    01-23-2006
    Location
    Exeter, UK
    MS-Off Ver
    2003
    Posts
    1,264
    This is cross posted

    http://www.excelforum.com/showthread.php?t=607874

    Ed

+ 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