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: <b>=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 </b>(if you want an exact match)<b>)</b>.
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.