I have two Excel Sheets in a single workbook. The sheet designations have
been changed from Sheet 1 and Sheet 2 to EXPENSE and MEDICAL. I wish to have
the contents of a single cell in MEDICAL (which contains a totals formula)
copied in the EXPENSE sheet, changing whenever the total changes in MEDICAL.
I am using Excel 2003.

In the "Expense" sheet, click in the cell where you wish to display the
total.
Enter " = " (no quotes)
Then navigate to the "Medical" sheet,
And click in the cell with the totals formula,
And just hit <Enter.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"NIMDRA" wrote in message
...
I have two Excel Sheets in a single workbook. The sheet designations have
been changed from Sheet 1 and Sheet 2 to EXPENSE and MEDICAL. I wish to
have
the contents of a single cell in MEDICAL (which contains a totals formula)
copied in the EXPENSE sheet, changing whenever the total changes in
MEDICAL.
I am using Excel 2003.