Macro to consolidate specific row data from other workbooks

Dhivagar

New Member
Joined
Oct 27, 2016
Messages
2
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
 

Forum statistics

Threads
1,085,542
Messages
5,384,330
Members
401,887
Latest member
Somesh

Some videos you may like

This Week's Hot Topics

Top