ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to create a "cover worksheet"? (https://www.excelbanter.com/excel-worksheet-functions/136247-how-create-cover-worksheet.html)

Doug Fox

How to create a "cover worksheet"?
 
Let say that there is a workbook consists of 6 worksheets. Each worksheet
contains detailed monthly income and expenses, e.g., from Jan to June,
prepared by staff. The manager can only need to read the summary of each
month, compare the summaries, review trending, etc. on the "cover
worksheet". In case he needs to understand the details, he could go to
individual worksheets.

How this can be done? Any pointers are appreciated.

Many thanks,




Anne Troy[_2_]

How to create a "cover worksheet"?
 
You likely need to sum across worksheets:
http://www.officearticles.com/excel/...rk sheets.htm
And here's some other tips you might be able to use:
http://www.officearticles.com/excel/...soft_excel.htm
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"Doug Fox" wrote in message
...
Let say that there is a workbook consists of 6 worksheets. Each worksheet
contains detailed monthly income and expenses, e.g., from Jan to June,
prepared by staff. The manager can only need to read the summary of each
month, compare the summaries, review trending, etc. on the "cover
worksheet". In case he needs to understand the details, he could go to
individual worksheets.

How this can be done? Any pointers are appreciated.

Many thanks,







All times are GMT +1. The time now is 10:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com