Some former students have come to me with a question. My instinct would be to have them do their data entry with a UserForm, but I doubt they have time to recode that. Here's their issue:
They are building a course planning worksheet for laying out a four year college plan, checking pre-reqs, etc. They have a list of all available undergraduate courses on a sheet. On their user input sheet, they use data validation to create a drop down that references this list of courses.
Their instructor has asked them to make the input sheet such that once a course is chosen it no longer appears in any of the other drop downs on the sheet.
If we were working with a userForm I could see how we could control the options that appear in a comboBox individually, but is there any good formula magic to handle this case?
I hope this question is clear...please let me know if I can provide any clarifying details.
They are building a course planning worksheet for laying out a four year college plan, checking pre-reqs, etc. They have a list of all available undergraduate courses on a sheet. On their user input sheet, they use data validation to create a drop down that references this list of courses.
Their instructor has asked them to make the input sheet such that once a course is chosen it no longer appears in any of the other drop downs on the sheet.
If we were working with a userForm I could see how we could control the options that appear in a comboBox individually, but is there any good formula magic to handle this case?
I hope this question is clear...please let me know if I can provide any clarifying details.