nancybrown
Well-known Member
- Joined
- Apr 7, 2005
- Messages
- 868
I have a table that contains jobs and competency requirements, 68 in all. Each job requiries different competencies. I've named the competencies: comp1 - comp 68.
I then have an employee table with competencies the employee possesses, they too vary and range from 1 - 68, also called comp1 - comp68.
I desperately need help writing a vba code that will run a loop to match competencies and return 3 top successors that match most or all of the position requirements.
I then have an employee table with competencies the employee possesses, they too vary and range from 1 - 68, also called comp1 - comp68.
I desperately need help writing a vba code that will run a loop to match competencies and return 3 top successors that match most or all of the position requirements.