I want cell entry to be identical on another sheet

N

NIMDRA

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.
 
R

Ragdyer

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>.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell data entering slow! 0
Creating list from values that meet multiple criteria from other sheet 1
Bugs in Office 2019 0
How to automatically paste cells from one sheet to another sheet? 1
Add numbers if cell fill is a certain color; How To? 5
External cell reference between two excel worksheets both in One Drive 0
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Copy corresponding cell in Column B if cell in A contains certain text? 1

Top