We have multiple workbooks we are working from 1) New Hire Workbook, 2) Library of Job Qualification workbook (displays path to the actual qualifications, it is a power query), 3) Actual Job Qualification tracker. The process we are wanting to create is A) We enter employee number to New Hire Workbook, this auto fills the employee information, including what position they were hired for. B) We would like for a formula or VBA to see the position then go look into the Library of Job Qualifications and auto load the Actual Job Qualification into the New Hire Workbook.
There are new job qualifications added once a week and each new employee gets their own workbook, which is also located on Sharepoint. All these workbooks are located on Sharepoint.
How can we do this or where do we start? Thank you in advance. This forum has been very helpful over the last year.
There are new job qualifications added once a week and each new employee gets their own workbook, which is also located on Sharepoint. All these workbooks are located on Sharepoint.
How can we do this or where do we start? Thank you in advance. This forum has been very helpful over the last year.
