![]() |
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, |
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