Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summarize the monthly recrods by name
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.misc
|
|||
|
|||
Summarize the monthly recrods by name
Subodh wrote on 6/2/2012 :
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. Perhaps... Use the AutoFilter feature to temporarily hide all rows except those that contain data for 'Mr X'! -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summarize the monthly recrods by name
On Jun 4, 1:34*am, GS wrote:
Subodhwrote on 6/2/2012 : Hi All, * * * * * As a part of my job, I need to put details of each person worked each day. For that, I create anexcelsheet 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. Perhaps... * Use the AutoFilter feature to temporarily hide all rows except those that contain data for 'Mr X'! -- Garry Free usenet access athttp://www.eternal-september.org ClassicVB Users Regroup! * * comp.lang.basic.visual.misc * *microsoft.public.vb.general.discussion HI Garry, THanks for your help and concern. However, probably u didn't get my point OR may be I couldn't make my point clear. I can't use the auto filter as these data are on different sheets of the workbook. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summarize the monthly recrods by name
Subodh presented the following explanation :
On Jun 4, 1:34*am, GS wrote: Subodhwrote on 6/2/2012 : Hi All, * * * * * As a part of my job, I need to put details of each person worked each day. For that, I create anexcelsheet 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. Perhaps... * Use the AutoFilter feature to temporarily hide all rows except those that contain data for 'Mr X'! -- Garry Free usenet access athttp://www.eternal-september.org ClassicVB Users Regroup! * * comp.lang.basic.visual.misc * *microsoft.public.vb.general.discussion HI Garry, THanks for your help and concern. However, probably u didn't get my point OR may be I couldn't make my point clear. I can't use the auto filter as these data are on different sheets of the workbook. Ok, I missed the part about using a separate sheet for each person AND a separate sheet for each day. Is this correct? If so it seems like way, way, way too much duplication to me when all data for all workers can be stored on a single sheet (for each month - or not) and totalled by name quite easily. In this case my suggestion would be one way to easily get the job done. Of course, there's other approaches you can take to work around the <IMO rather poor design of your project. That said, I think you need to rethink your approach if you expect to achieve optimal productivity with it! -- 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 | |||
How can I add "monthly" tabs that summarize a yearly report? | Excel Worksheet Functions | |||
Rolling Monthly Amounts to Annual Monthly Amounts | Excel Discussion (Misc queries) | |||
summarize | New Users to Excel | |||
How do I set up monthly random work schedule for 60 hours monthly | Excel Discussion (Misc queries) | |||
Mortgage template comparing interest pd, monthly, bi-monthly, ext. | Excel Discussion (Misc queries) |