Copy cell range from another sheet based on drop down selection.

**nhen.enry** · 08-09-2012, 06:26 PM

Hello everyone! I am currently working on a classroom behavior monitoring system. In sheet1-column 1, 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. Please help.

**Cutter** · 08-09-2012, 08:07 PM

Hello nhen.enry, and welcome to the forum.

I see you have posted your question where it should be. This area is strictly for introducing yourself. Hopefully you'll soon get the help you want.

Enjoy your membership!