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.

Howdy. Set up the original to get the exact same cell, then check out the OFFSET function. It should do what you want.