Dear Excel experts,
My query is detailed below.
Given below is my consolidated worksheet.
I will receive workbook with name as "Emp ID"(name is "96521" in this case). The workbook will have Name and age of the employee.
I need a macro in my consolidated sheet which will use Emp ID as reference and update the details. Upon running the macro the source sheet should be updated like below.
Kindly help
My query is detailed below.
Given below is my consolidated worksheet.
I will receive workbook with name as "Emp ID"(name is "96521" in this case). The workbook will have Name and age of the employee.
I need a macro in my consolidated sheet which will use Emp ID as reference and update the details. Upon running the macro the source sheet should be updated like below.
Kindly help
