Hi Everyone.
I am really hoping to get help here.
I have created a course booking form which automatically calculated the total training cost and cost of any replacement if required.
Everything works as it should (Please see the sample book) but as you can see I am using a data validation list which is a pain when you have to select from over 300 employees...
What I would like to have is few combo boxes like the ones in a sample book which would filter the next combobox base on selection in previous combobox this way a Manager can select his area/department and select only people from his team rather that from all departments and choosing from over 300 people....
In addition to this, once the name is selected I would like to have button that says "Nominate this Colleague for the Course" which will record the combo box content in the next empty cell.
Thanks in advance.
Dan
Bookmarks