How to add totals in one sheet to another sheet

How do I add cells in one sheet to cells in another sheet in the same workbook?
For example:
Sheet one name is draw 1.
Sheet two name is draw 2.
I want to copy totals in D4 in sheet one to sheet two d4.

Thanks for your help.

Katie

D4 on Draw 2 should be

='Draw 1'!D4

- Search

"k.floyd" wrote:

>
> How do I add cells in one sheet to cells in another sheet in the same
> workbook?
> For example:
> Sheet one name is draw 1.
> Sheet two name is draw 2.
> I want to copy totals in D4 in sheet one to sheet two d4.
>
> Thanks for your help.
>
> Katie
>
>
> --
> k.floyd
> ------------------------------------------------------------------------
> k.floyd's Profile: http://www.excelforum.com/member.php...o&userid=28677
> View this thread: http://www.excelforum.com/showthread...hreadid=483529
>
>