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

Try this:

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

HTH,

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


"Ket" wrote in message
...
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

Thank you

On Tue, 22 Feb 2005 05:10:23 -0800, "RagDyeR"
wrote:

Try this:

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

You're welcome.
--

Regards,

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

"Ket" wrote in message
...
Thank you

On Tue, 22 Feb 2005 05:10:23 -0800, "RagDyeR"
wrote:

Try this:

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