Get txt from 'colA' of 'wrkst 1' and find in 'wrkst 2' then replace with txt from 'colB'

[A.J. Sobh]

Hello Everyone,

I have found several similar threads, but I am new to VBA and can't seem to figure out the optimal solution to my problem.

Problem:
I have two workbooks. Let's call them WORKING and MASTER.

The MASTER file contains two columns of names. Column A contains the original names (to be searched for in the WORKING file) and Column B contains the respective replacement names (to replace the original names in the WORKING file). I have attached a simplified version of the MASTER file.

Attachment 317097

The WORKING file uses the original naming convention. I have attached a simplified version of the WORKING file.

Attachment 317099

What I am Looking For:
I would like to run a macro which searches the WORKING file for all the ORIGINAL names from the MASTER file and replaces the found items with the corresponding NEW names from the MASTER file.

Assumptions:
The macro will be called from the WORKING file.
Both workbooks will be open.
The Worksheet of the MASTER file will be called 'Lookup Table'

Any advice would be greatly appreciated. Thank you.

A.J.

[ihmha]

The following should work

option 1 will match the whole cell value against the name being searched
option 2 could give problems if for example you have the name fred as a search and the name alfred being replaced

Please Login or Register  to view this content.

[A.J. Sobh]

Amazing stuff. Thank you so much for your help. I really do appreciate it.