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