+ Reply to Thread
Results 1 to 3 of 3

Rookie: Trying to make a list with multiple selection capabilities

  1. #1
    Registered User
    Join Date
    10-03-2012
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Rookie: Trying to make a list with multiple selection capabilities

    Hi all,

    First post so bare with me. I have frequented the site forever and have walked away with some great solutions to problems I've run into in excel. I'm working a minor project but my manager is describing something that he wants that seems so easy, yet it's frustrating the heck out of me. I'm no wizard in excel so I'll say that first. Here's what I've been tasked to do:

    Situation:
    There are multiple training sessions that will be rolling out in Q1 13 and my manager needs a way to track which empolyees have been to which training sessions. Easy enough. He wants something extremely clean looking, but obviously efficient. What he described to me (his vision) is to have the training sessions listed into columns with drop down under each that contain every employee's name. So when a training session is held, he can easily click the drop down beneath the session title and select multiple persons that were in attendance. Right now I just have all the employees listed in column A and all the training sessions listed across the top and anticipated just putting a "x" in the box for the session that each person attends. This will accomplish exactly what he's looking for, but if what he's describing is remotely possible I would like to do that.

    Please let me know if what I'm describing is possible. Any help would be greatly appreciated. I hope I'm not breaking any forum rules here

    Cheers

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Rookie: Trying to make a list with multiple selection capabilities

    hi DShack and welcome to the forum (nope your not breaking any rules lol)

    It might be easier to offer some suggestions if you have something for members here to base them off?

    As I was reading what you want, the option you mentioned is what came to my mind too (a matrix), but im sure we can put something together that would suite the boss's needs

    If you have something started already, maybe you could upload a sample of that for us to play with? (all sensitiv data removed of course)

    To Attach a
    File:

    1. Click on Go Advanced
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.
    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
    10-03-2012
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Rookie: Trying to make a list with multiple selection capabilities

    Thanks for the direction. Here's a dummy version of what the data looks like right now. Again, what I'm looking for is a way to take a training session and select multiple participants that were in attendance. Let me know if there's more I can do to help get some further direction. Thanks again.
    Attached Files Attached Files

+ 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1