Hello,
I've two excel files (A and B ). File A got Names of 1000 employees of our firm. File B is complete list and got names of 35000 employees of our firm including their location and country.
A macro should compare names between File A and B and populate Location in File A after looking up in File B
Example:
File A
<tbody>
</tbody>
File B
<tbody>
</tbody>
Desire OutPut
A macro should compare names between File A and B and populate Location in File A after looking up in File B
File A
<tbody>
</tbody>
Hope someone can assist with my issue.
thanks
I've two excel files (A and B ). File A got Names of 1000 employees of our firm. File B is complete list and got names of 35000 employees of our firm including their location and country.
A macro should compare names between File A and B and populate Location in File A after looking up in File B
Example:
File A
Name | Location |
Andrew Corey | |
Michael Wilson |
<tbody>
</tbody>
File B
Name | Location | Country |
Richard Spicer | New York | USA |
Michael Wilson | Chicago | USA |
Rajesh Sharma | Barcelona | Spain |
Andew Corey | Seattle | USA |
<tbody>
</tbody>
Desire OutPut
A macro should compare names between File A and B and populate Location in File A after looking up in File B
File A
Name | Location |
Andrew Corey | Seattle |
Michael Wilson | Chicago |
<tbody>
</tbody>
Hope someone can assist with my issue.
thanks