So here is my problem.
I have three data sections (Day, Session, and Course)
Day - Monday through friday (drop down already created)
Session - Only session 1 or session 2 (drop down already created)
Course - Certain courses are only available during certain days and certain sessions (this is the drop down i need help with)
How do i create a drop down list that only returns the course available for the day and session listed above?
I have attached a sample workbook, the drop downs are found in the attendance tab while the courses available during each day an session are in the codes tab.
Any help would be greatly appreciated.
Thanks in advance
Los
Bookmarks