Finding and replace from different sheets

HI,

it is my first post.

I need to have a micro to find and replace between different sheets in same workbook.
the cells which will be replaced could be changed in location within same sheet, and number of rows not fixed (i want to search in whole sheet).

the search could be with exact cell value but it will be better if we can search string within a cell.

the new data are in another sheet in two columns A column contains to be replaced value and B column contains the new value. also the number of rows is changeable.

below is a sample where sheet2 contain the old and new values

It is look like a difficult request.
no one can help?

Here deals with part of the problem, it does not loop through sheets, but look at two sheets. Try it

Please Login or Register  to view this content.

Thank you.
It works and really helped

AB33 & Mike -

I guess the safe loop would be

Please Login or Register  to view this content.

otherwise, it will return incorrect results.
Abis1 will replace all instance like Abis10,11,12,etc

event

Thanks Mike and events21!
The other bit which has not being resolved is to loop through each sheets. I was wondering how you can speed up an already slow code.

Hi -

I think 20 secs for this purpose is not bad at all.

event

Thank you all