+ Reply to Thread
Results 1 to 14 of 14

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

  1. #1
    Registered User
    Join Date
    08-09-2012
    Location
    usa
    MS-Off Ver
    Excel 2007
    Posts
    10

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

    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.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,078

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

    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
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    08-09-2012
    Location
    usa
    MS-Off Ver
    Excel 2007
    Posts
    10

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

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

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,078

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

    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?

  5. #5
    Registered User
    Join Date
    08-09-2012
    Location
    usa
    MS-Off Ver
    Excel 2007
    Posts
    10

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

    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.

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,078

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

    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
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    08-09-2012
    Location
    usa
    MS-Off Ver
    Excel 2007
    Posts
    10

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

    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!!!
    Last edited by Cutter; 09-07-2012 at 03:44 PM. Reason: Added code tags

  8. #8
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,078

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

    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

  9. #9
    Registered User
    Join Date
    08-09-2012
    Location
    usa
    MS-Off Ver
    Excel 2007
    Posts
    10

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

    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
    Last edited by nhen.enry; 09-05-2012 at 11:54 PM.

  10. #10
    Registered User
    Join Date
    08-09-2012
    Location
    usa
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Populate Table with data from other sheets based on drop down selection - SOLVED...

    This case has been SOLVED. Thanks FDibbins.

  11. #11
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,053

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

    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
    HTH
    Regards, Jeff

  12. #12
    Registered User
    Join Date
    08-09-2012
    Location
    usa
    MS-Off Ver
    Excel 2007
    Posts
    10

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

    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.

  13. #13
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,053

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

    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.

  14. #14
    Registered User
    Join Date
    08-09-2012
    Location
    usa
    MS-Off Ver
    Excel 2007
    Posts
    10

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

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts