Ok, here goes...
I have a very large talent management database that is housed in Excel. This database includes information on performance ratings, work history, education, etc. on every employee in the company.
I also have a 'Talent Profile' form (also created in Excel) that I give to HR whenever they need to review an incumbents talent management information. This form includes most of the information on the talent management database, but not all. And, it's in a completely different format.
Currently, I'm manually entering all of the information into the 'Talent Profile' form from the data on the talent management database. Ideally, I would like to enter the employee's ID number and have the form automatically populate based on the relevant information from the talent management database.
Is this possible? If so, I'm assuming it will require a macro...
Thanks in advance for the help!
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!