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? |
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? |
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? |
All times are GMT +1. The time now is 09:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com