How to start some function between 2 Excel Books?

[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.

[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.

[shg]

I'm sure I'm missing something: Why not just drag the formula down?

[databases1980]

I tried it and it did not work properly.
It just repeated the patterns of the above cells in the SAME Excel book...
While I wanted the cells to be written with data from the OTHER book.


Thanks again.

[shg]

Perhaps post two worbooks that illustrate what you tried that doesn't work.

[Norie]

Can I ask a question?

How many forums have you posted this in so far?

[shg]

Threads merged.

databases1980, please read the Forum Rules.

[databases1980]

I have posted this in 3 Excel Forums that I know.


I do not have the Excel Book right now in order to attach. But I think the issue is clear from the statement of it above.

I just want to make a formula on a certain book which gets the data from a column of another book.


Thanks

[shg]

I have posted this in 3 Excel Forums that I know.

I think you will find that's a good way to get ignored.

[databases1980]

I don't find it strange that someone posts a question in a number of forums online!

Besides, what is sure is that there wasn't a good answer at your forum.