Automatically populate a form based on a match from another worksheet.
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!
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!
ASKED:
Jan 28, 2009 6:18 PM GMT
UPDATED:
February 25, 2009 10:05:12 AM GMT
RELATED QUESTIONS
- Pulling additional data fields along with the primary field in a DBColumn lookup.
- Access 2007 form creation
- automatically populate field sequentially from list
- School Project-setting up a network from the ground up for a real estate business that has 10 satellite offices. $125,000 budget.
- Auto-Populate an Access form using a table of values
- Export tabels from SQL Server to iSeries
- Product Review - UniPaaS, RAD Tool, Unique development paradigm
- Issue viewing "additional controls" for toolbox in VBE
- Data entry and calculations in the same cell
- Access 2007 form creation
Answer Wiki:
If I understand this problem correctly it solved pretty straightforward using the “vlookup” function. Basically this function looks up a value and returns the corresponding value in that row for a column of your choice. (the employee id number has to be the first column and 100% unique).
What you could do is enter the employee id into the ‘talent profile form’. Then select for example the cell that should contain the employee name. In this cell input the vlookup formula: =vlookup(cell in the ‘talent profile form’ that contains the employee ID, database that contains the data, column in the database that contains the employee name, false (if you want an exact match)).
Repeat this for all cells you need to fill in the ‘profile form’ and they should be automatically generated when you enter the employee id.
No need for macro’s.
Dan
What you could do is enter the employee id into the ‘talent profile form’. Then select for example the cell that should contain the employee name. In this cell input the vlookup formula: =vlookup(cell in the ‘talent profile form’ that contains the employee ID, database that contains the data, column in the database that contains the employee name, false (if you want an exact match)).
Repeat this for all cells you need to fill in the ‘profile form’ and they should be automatically generated when you enter the employee id.
No need for macro’s.
Dan
15 pts.
To see other answers submitted to the Answer Wiki View Answer History.
