Retrieve value from Same Cell, 25 Sheets

[mtpaper]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi
I have a workbook, with let's say 25 sheets.
I want range b1.b25 of the 26 sheet to have the contents of Cell-K25 from each of the first 25 sheets.

How do I do that????

I don't want the SUM of all the K25 cells to wind up in one cell on the 26th page.

Thank you!
Marion

 

[Laroche J]

Hi
I have a workbook, with let's say 25 sheets.
I want range b1.b25 of the 26 sheet to have the contents of Cell-K25 from each
of the first 25 sheets.

Unfortunately there is no fast way to do it.
In B1, type the equal sign, click on the tab of the first sheet, click on
cell K25, then press the Enter key.
In B2, type the equal sign, click on the tab of the second sheet, click on
cell K25, then press the Enter key.
etc.

JL
Mac OS X 10.4.11, Office v.X 10.1.9

 

[CyberTaz]

One suggestion that "might" be a bit faster:

Unfortunately there is no fast way to do it.
In B1, type the equal sign, click on the tab of the first sheet, click on
cell K25, then press the Enter key.
In B2, type the equal sign, click on the tab of the second sheet, click on
cell K25, then press the Enter key.
etc.

JL
Mac OS X 10.4.11, Office v.X 10.1.9

Create the first formula as =Sheet1!$K$9
Copy it down to row 25
Then work your way down changing the name of the sheet in each formula.

HTH |:>)
Bob Jones
[MVP] Office:Mac