I have two different work books on which is a skills matrix and one which is the training plan.
From the information in the training plan i want to auto populate the required cells in the skills matrix.
The skills matric we have each member of my team in different rows.
There will be a different work book names as each employee.
I need a formula in the skills matrix which will reference the persons name then search it on the personal training plan workbook then grab the information and generate it in the skills matrix.
If possible is the a way for the information to update if one os the workbooks is closed at any time.
By: James Allen