Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summarize information on different sheets of the workbook
Hi All,
As a part of my job, I need to put details of each person worked each day. For that, I create an excel sheet for each day of the months and list all the details of the person worked in that day on the sheet for each person. So, basically a sheet will have name of person in the rows and on the columns it will have details of works done on the particular day - it works fine upto this. Now, I would like to get the information / list / summary at the end of the month - for a particular person say Mr X. It can be done by going to each day and then compiling the details. But, as the data is already there for each day, is there any way out to get that summary automatically or using some of the excels advanced features. Any help and / or tips will be highly appreciated. Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summarize information on different sheets of the workbook
See your post in the other forum...
Also, please learn how to 'cross-post' rather than multi-posting to several forums. Cross-posting allows replies to be updated in all forums where you put your post. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking sheets to summarize data | New Users to Excel | |||
how to share information between sheets in a workbook | Excel Worksheet Functions | |||
Summarize data from multiple sheets | Excel Discussion (Misc queries) | |||
Summarize information on another sheet | Excel Worksheet Functions | |||
How to summarize two sheets in the third sheet | Excel Programming |