Summarize the monthly recrods by name

[Subodh]

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.

 

[GS]

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

 

[Subodh]

Subodhwrote on 6/2/2012 :


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.

 

[GS]

Subodh presented the following explanation :

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