Thread: I want cell entry to be identical on another sheet

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" <NIMDRA@discussions.microsoft.com> wrote in message
news:00D0349F-2716-49DD-BE14-31A10458B431@microsoft.com...
> 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.