| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LINKING TOGETHER FOR TOTAL
I would like to know how to create a summary sheet for a workbook, for
example if I create worksheets for 3 branches of a company with the same headings and formulas, how do I do a total summary sheet for all three together? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
LINKING TOGETHER FOR TOTAL
Caroline
I don't know if this is available in the version of Excel you are using but in Excel 2003 try Consolodate on the Data manu. Dave "Caroline7361" wrote in message ... I would like to know how to create a summary sheet for a workbook, for example if I create worksheets for 3 branches of a company with the same headings and formulas, how do I do a total summary sheet for all three together? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
LINKING TOGETHER FOR TOTAL
Hi Dave, thanks for the reply. I have had a look and it is on it but I still
don't know how to use it. Can you advise please? "Dave" wrote: Caroline I don't know if this is available in the version of Excel you are using but in Excel 2003 try Consolodate on the Data manu. Dave "Caroline7361" wrote in message ... I would like to know how to create a summary sheet for a workbook, for example if I create worksheets for 3 branches of a company with the same headings and formulas, how do I do a total summary sheet for all three together? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
| Linking worksheets | Excel Worksheet Functions | |||
| Dynamic Linking | Excel Discussion (Misc queries) | |||
| Have to use cursor keys cannot use mouse in excel when linking fo. | Excel Worksheet Functions | |||
| Linking Workbooks | Excel Worksheet Functions | |||
Linear Mode
