Find and Replace Macro code for multiple replacement

[dawoodmpm]

Hi friends,

I want run a find and replace on multiple values from 2 column.

I have2 Excel files,files from the first worksheet contains old Room number and new room number
Column-A Column-B
Old Room tag New room Tag

-1.712 B-R121
-1.651 C-F677
- - - - around 500 values continues in columns as mentioned above.

In 2nd files contain multiple worksheet (50 worksheet),I have to change Old room tags as new. i am struggling to change those taggs.Please advice.

[dawoodmpm]

:banghead:

[macropod]

This thread is a duplicate of: http://www.vbaexpress.com/forum/showthread.php?64251-Find-and-Replace-Multiple-values-in-Excel
Kindly don't ask the same question in multiple threads. Thread closed. You may continue the discussion in your original thread.