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.

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

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.

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