Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Move the last entry in a column to a different cell, when the loc. | Excel Worksheet Functions | |||
Automatic cell increment with data from sheet 1 to sheet 2 | Excel Worksheet Functions | |||
how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |