I need some help with creating a dynamic drop down. I'm stumped as to how this can be achieved. Thank you for your help in this!
I have two worksheets. The first worksheet contains the names and their Available Times and Days.
On another sheet, I have a course name and the time and date of the course. I want to be able to select an engineer to attend the course based on the conditions that the engineer is available on the said day and time.
Training Tracker Test.xlsx
Last edited by psilens; 01-27-2014 at 09:47 AM.
welcome to the forum psilens ! Please upload a work book with sample data
to attach a workbook go to advanced tab ---> select paper clip icon OR select manage attachment
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
thanks i have updated my post
would anyone be able to help with this? thanks!
Hello Psilens !
Find attached !
if this helps click "*" add rep icon in the bottom left corner of my post!
Last edited by hemesh; 02-01-2014 at 02:27 AM.
Hi Hemesh, Thanks for the help on this one. I wanted to add one more condition that needs to be checked where the person should not be on leave on the said date of the training. I'm thinking another sheet which lists the leave dates of the person. Is this doable? I'll post a revised file by tomorrow. Thank you again for your help.
Training Tracker Test 2.xlsx
I think I broke the formula. I tried to expand it to also try to incorporate leave dates but I broke it. Please can you fix it? Thanks a ton!
are there more than 11 courses !
I will be updating this in couple of hours!
Yeah there are around 5 courses per month and 10 schedules per course. 15 people need to be able to attend at least 3 courses each month. Scheduling is a pain, it currently takes around 1-2 hours scheduling manually with lots of errors and conflicts... thanks for the help hemesh
Re: How to create a dynamic dropdown based on multiple lookup conditions
Hello Q
Find attached ! You need to use a helper sheet to manage dropdowns ! Formulas marked in yellow are array formulas you need to hold control and shift together and then hit enter and release all three keys for these formulas to work.!
Sheets with leave details will show not applicable if your en. is on leave for the day of training !
Hope this helps!
Is there a way for the people on leave not to show up on the drop down if they out on the same date as a course? thanks so much for this hemesh. This is a big help to free up some of my time and save me some headache. really grateful
Last edited by psilens; 02-06-2014 at 12:03 AM.
Just drag all the columns of helper sheet!
for the adding, i also expanded the formula to go all the way up to row 50. thanks!
for the leaves, is there a way for people on leave not to show up on the drop down list of the course of the same date. It will be the 3rd condition.
I got around a simpler way just counting the conflicts. Thanks again for the help in this hemesh!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks