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.