Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2008

    Unanswered: How to make a function between 2 Excel Books?

    Good day!

    I would like to ask about the following:

    I am creating a new Excel sheet in a new Book, and I want to reference another cell in another Excel Book. OK I know how to do this.
    But I want the following cells to "Automatically" get the corresponding cell values from the other Excel Book Sheet.
    For example if cell B1 from Book2-Sheet5 gets the value of cell A7 in Book1-Sheet2, and B2 gets that of A8.... I want the following ones to get the corresponding values (B3 gets that of A9 and B4 gets that of A10, ETC...)

    I am sure we can do this in Microsoft Excel, but don't know how.

    Thank you very much.
    Hope to hear from you soon.

  2. #2
    Join Date
    Oct 2003
    Howdy. Set up the original to get the exact same cell, then check out the OFFSET function. It should do what you want.
    old, slow, and confused
    but at least I'm inconsistent!

    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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