Help with creating

[DebbieDoesData]

Hi everyone,
I am new to the forum and while I enjoy using excel (2010), I am still very much a novice. I would truly appreciate some help designing a summary attendance sheet that would pull information from across sheets for each individual class.

Here is what ideally I would need for it to do.
As people register for classes, they would be input into the class roster. Their attendance hours are tracked each individual date for each class and I can find out their total hours for each class.

I would like for there to be a summary sheet, that automatically populates the participants' names into the summary sheet and then tells me the total hours of participation, and finally, would highlight the participants (conditional formatting) once the participant reaches 50 hours and above.

My difficulty is with having the participants listed in the summary sheet because participants are signed up for any number of classes. Some may only be taking one class, while others may be in multiple classes, so I do not want the participants to be listed multiple times, rather listed once, and then having the attendance from each class calculated as their total hours on the summary page.

I may need you to explain it to me like I am a 5 year old, but I would be very grateful for any assistance. Any help is greatly appreciated! Additionally, if anyone has recommendations on these kinds of tutorials, feel free to point me in that direction. I am a novice but am looking to expand my knowledge in any way.

-Debbie

 

[DebbieDoesData]

Hi Renaissance,
I have run into another issue and was hoping you can help me. I have added some things to fit our needs to the original sample you sent me and it has worked well. But through some trials, I realized we are running into a small issue. I added an additional identifier (I split the columns so that there is a Last Name column, and a First Name column) which was working well, until I encountered two people with the same last name. The problem I am running into is that when I am adding specific class hours for one individual (just as an example let's say Mickey Mouse), it is also filling in the same number of hours for anyone on the summary sheet with the same last name (so for instance, it is also adding those hours for Minnie Mouse, because they both have the same last name, Mouse.) How would I go about fixing this?

Thanks in advance to you or anyone who reads this!

 

[Renaissance]

Hey Debbie,

Sorry I didn't respond to your previous post, but I am glad things are generally working well for you.

So this identifier issue is easy to remedy. What it will truly depend on is how specific you want/need to get. I'll be at my home computer later and I will write up some new formulae if you'd like. Are you wanting everything to calculate based on entire name? Full first and first initial of last name? Let me know and I will work with you on a new direction.