J
JNW
I work with an organization that just changed how they want us to report
to them. Unfortunately this change effectively eliminated any
capabilities that we had in the past to make summary reports for
ourselves.
What happens now:
-We hold events that our members go to in order to complete time
requirements. We record these into a worksheet provided by the
national office. There is one worksheet per event (about 200 sheets at
the moment). This workbook provides a summary of how the organization
as a whole is doing and sums the total hours but does not provide for a
summary of how many hours each individual has.
I have created (so far) a workbook that gets the individual's names
from each worksheet, compiles the list and gets rid of placeholders
(person1,2,etc) and duplicates. Also from that list I have created
macros that copy into a summary sheet the headings from the various
worksheets. All of these are called in the open event (but disabled at
the moment).
**What I can't figure out is a way to loop through the data entry
worksheets, look for each person's name (split into two cells with last
name and first name separate) and return the individual hours for each
person for each event in a chart on the summary page. **
I've attached the summary workbook for you to look at.
Thank you.
JNW
+-------------------------------------------------------------------+
|Filename: Reports test.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4080 |
+-------------------------------------------------------------------+
to them. Unfortunately this change effectively eliminated any
capabilities that we had in the past to make summary reports for
ourselves.
What happens now:
-We hold events that our members go to in order to complete time
requirements. We record these into a worksheet provided by the
national office. There is one worksheet per event (about 200 sheets at
the moment). This workbook provides a summary of how the organization
as a whole is doing and sums the total hours but does not provide for a
summary of how many hours each individual has.
I have created (so far) a workbook that gets the individual's names
from each worksheet, compiles the list and gets rid of placeholders
(person1,2,etc) and duplicates. Also from that list I have created
macros that copy into a summary sheet the headings from the various
worksheets. All of these are called in the open event (but disabled at
the moment).
**What I can't figure out is a way to loop through the data entry
worksheets, look for each person's name (split into two cells with last
name and first name separate) and return the individual hours for each
person for each event in a chart on the summary page. **
I've attached the summary workbook for you to look at.
Thank you.
JNW
+-------------------------------------------------------------------+
|Filename: Reports test.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4080 |
+-------------------------------------------------------------------+