Populate Table with data from other sheets based on drop down selection

[nhen.enry]

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.

[FDibbins]

i would be able to help more if i could see a sample of your worksheet, rather than a picture. im sure what you want is do-able without too much trouble tho

[nhen.enry]

Thanks again. Attached is the file. Please ignore sheet3.

[FDibbins]

sheet1 and sheet2 seem to contain the same data. would this be a month-to-month register that you would need to track behaviour by month on?

[nhen.enry]

Sheet1 is just an easier way to input the data. The cell font is set to Marlett so that it will register a check entry if "a" is entered. The user need not enter anything for a "NO" or "X" as a blank cell automatically registers a "NO" entry in sheet2. The data looks better visually with checks and blank. In sheet2, the data is converted to a "Y" and "N" which is the basis of the behavior summary. Yes it will be for a monthly monitoring...and I'll just update the workbook for the other months. Huge thanks for your attention and willingness to help.

[FDibbins]

see if the attached is what you are looking for. i changed the values on sheet2 to test the formulas to make sure they are returning the correct values. Also, i changed your 1st name drp-down to a lookup, to make things easier (either way, you are picking a last name, and then a 1st name)

Im not sure if you will be doing this on a month-to-month basis, at the moment, it is just set up for the month you provided

[nhen.enry]

Many,many, many, maaaaaaannnnnnyyyyy THANKS. This is EXACTLY WHAT I NEED!!!!!!!!!!!!!!! You have ERADICATED my week-long MISERY!!! Thank you, thank you, than you, thank you! And i loved what you did with the first name (changing it to a look up). It erases the problem of having two people with same name. I'll have to study what you did so I can increase my knowledge.

You are God sent!!! THANKS AGAIN!!!

[FDibbins]

im glad i was able to help , and thanks for you'r kind words.

seeing as this answered your question, please take a moment to mark the tread as "solved" - it helps keep things neet and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below

[nhen.enry]

I'm sorry...I did not know that you responded to my last message. I'm not sure where or how to mark the case solved. I'd appreciate it if you could show me. However, I have one "formula" concern which i hope to get assistance from you. On Sheet 5 of the attached behavior monitoring file, on cell M8, I wanted that cell to display the formula value of C8. However, I wanted the cell to display "NA" if the date on B8 is a saturday or sunday. As you will see, the cells from B6 to V36 gets greyed out if the date on the B column falls on a Saturday or Sunday.

English2 Behavior Monitoring Modified.xlsm

[nhen.enry]

This case has been SOLVED. Thanks FDibbins.

[jeffreybrown]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[nhen.enry]

Thanks. for the directions. I have a related post in this thread just yesterday (seeking help with formula). Should I post that in another thread? Thanks, again.

[jeffreybrown]

Yes, you might want to start a new thread so as you get the most exposure possible. This one has a thread count that is getting up there.

[nhen.enry]

Thanks....but I figured it out...it feels great to learn!