Hi everyone! I'm a newbie here. I am currently working on a classroom behavior monitoring system. In sheet1-leftmost column, is the list of students. Running across the page are expected behaviors for each day (Please see Behavior Monitoring attachment). Cell entries will simply be Y (for YES) and N (for NO) linked from similar sheet.

Behavior Monitoring.jpg

In sheet2, I want to be able to generate an individual student behavior summary showing his/her demonstration (or non-demonstration) of each expected behavior for the week/s or month if I select him/her from a drop down list. (Please see Behavior Summary attachment)

Behavior Summary.jpg

I have read some related posts, but they are not totally the same as mine. Additionally, I really struggle with VB codes and FUNCTIONS. Please help.