tina.tjoeng
New member
- Joined
- Aug 4, 2015
- Messages
- 14
- Reaction score
- 0
- Points
- 0
Hi All,
Thank you in advance for your assistance. I'm after a dependant drop down list for more than 2 dependencies in the sample data provided View attachment Sample.xlsx
I have the following:
Data_Entry Tab: Where information is keyed in
Course List Tab: List of Courses and course Numbers
Learner List Tab: List of Learners and their user IDs
Concept:
In the Data_Entry Tab:
Learner List:
Apologies, lastly, I'll need to include conditional formatting or some sort of indicator if a completion record of the same course and completion date by learner is entered in twice?
Hope someone will be able to help
Thank you
T
Thank you in advance for your assistance. I'm after a dependant drop down list for more than 2 dependencies in the sample data provided View attachment Sample.xlsx
I have the following:
Data_Entry Tab: Where information is keyed in
Course List Tab: List of Courses and course Numbers
Learner List Tab: List of Learners and their user IDs
Concept:
In the Data_Entry Tab:
- The aim is to eliminate as much manually keying in of information, so it would be to create dependant drop down lists that would narrow down values in the following drop down lists selected. eg. Division, you'd have a select of HSSE, External, Mechanical, Operations etc, then from there, one would select Proficiency Level of Knowledge, Interim Skill or Skill, then from there you would select the unit name that corresponds to that particular division and proficiency, eg. Forklift is a HRL proficiency and would be a course only found under External division etc. (I hope that made sense)
- I figured it out for 1 dependency but was not able to figure out how to do this with 3 pieces of information that were dependant on eachother to get the right value
- Then in Course Code and Module Code field, the course and proficiency selected needs to retrieve the corresponding course and module Codes
Learner List:
- This is in a different format to how it is entered into the Data_Entry Tab, so would need a formula in the User ID column in Data_Entry Tab to retrieve the corresponding user ID, Learner List will be upldated by system report which has full name in that format (would like to reduce the amount of formatting and cutting/changing of data required)
Apologies, lastly, I'll need to include conditional formatting or some sort of indicator if a completion record of the same course and completion date by learner is entered in twice?
Hope someone will be able to help
Thank you
T
Last edited: