[databases1980]

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.

[shades]

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