Index/Lookup problems
 

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 |
+-------------------------------------------------------------------+

--
JNW
------------------------------------------------------------------------
JNW's Profile: http://www.excelforum.com/member.php...o&userid=29201
View this thread: http://www.excelforum.com/showthread...hreadid=489350

Index/Lookup problems
 

Your workbook was less than helpful, not data sheets, just a master. That
bit we can figure, the data we cannot.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JNW" wrote in message
...

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 |
+-------------------------------------------------------------------+

--
JNW
------------------------------------------------------------------------
JNW's Profile:
http://www.excelforum.com/member.php...o&userid=29201
View this thread: http://www.excelforum.com/showthread...hreadid=489350

Index/Lookup problems
 

Sorry about that. I had forgotten to include it. What is attache
below is about 5% of the actual sheets. All but one of the sheet
contain data that we have entered in, the other is what the "blank
looks like.

One other note. The data sheets (in the original file) are passwor
protected with and I don't want to go through the trouble of trying t
crack it.

Thank you for your reply.

JN

+-------------------------------------------------------------------
|Filename: Data Sheets.zip
|Download: http://www.excelforum.com/attachment.php?postid=4082
+-------------------------------------------------------------------

--
JN
-----------------------------------------------------------------------
JNW's Profile: http://www.excelforum.com/member.php...fo&userid=2920
View this thread: http://www.excelforum.com/showthread.php?threadid=48935