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
Bookmarks