| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to copy formulas sheet to sheet in excell
how do I copy a sum in a cell on sheet 1 that the sum changes as data is
entered to sheet 2 and always have the updated sum of sheet 1? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to copy formulas sheet to sheet in excell
Can I read this as: you want to sum a range of values in Sheet2 but wish to
see the answer in Sheet1? =SUM(Sheet2!A1:A100) If the sheet name contains spaces you need to put it within single quotes =SUM('Weekly Sales'!A1:A100 If I am off the mark please rephrase your question and I will try again best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Kathy" wrote in message ... how do I copy a sum in a cell on sheet 1 that the sum changes as data is entered to sheet 2 and always have the updated sum of sheet 1? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy formulas down a sheet using increments? | Excel Discussion (Misc queries) | |||
| how to copy row heights from one sheet to another in Excell | Excel Discussion (Misc queries) | |||
| how to copy row heights from one sheet to another in Excell | Excel Discussion (Misc queries) | |||
| insert query into excell sheet to update excell sheet and pivot table | Excel Discussion (Misc queries) | |||
| How do you copy a sheet (with Formulas) to another Workbook? | Excel Discussion (Misc queries) | |||
Linear Mode
