3D Workbook??

[Ket]

Hello,

I have a workbook that contains a number of worksheets. Each sheet is
identical in layout and contains amongst other things a sum total in
cell D3.

When I create a summary sheet, I can click into a cell and create the
formula =Sheet1!D3.

Is it possible to be able to drag this cell down so that the next
cell displays the result =Sheet2!D3, and so on and so forth?

TIA for your assistance.

Ket
London

[RagDyeR]

Try this:

=INDIRECT("Sheet"&ROW(A1)&"!D3")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Ket" <[email protected]> wrote in message
news:[email protected]...
Hello,

I have a workbook that contains a number of worksheets. Each sheet is
identical in layout and contains amongst other things a sum total in
cell D3.

When I create a summary sheet, I can click into a cell and create the
formula =Sheet1!D3.

Is it possible to be able to drag this cell down so that the next
cell displays the result =Sheet2!D3, and so on and so forth?

TIA for your assistance.

Ket
London

[Ket]

Thank you

On Tue, 22 Feb 2005 05:10:23 -0800, "RagDyeR" <[email protected]>
wrote:

>Try this:
>
>=INDIRECT("Sheet"&ROW(A1)&"!D3")

[RagDyeR]

You're welcome.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"Ket" <[email protected]> wrote in message
news:[email protected]...
Thank you

On Tue, 22 Feb 2005 05:10:23 -0800, "RagDyeR" <[email protected]>
wrote:

>Try this:
>
>=INDIRECT("Sheet"&ROW(A1)&"!D3")