Multiple find and replace for multiple sheets

I hope I understand your question because it sounds like you want to do a lot of different find and replace statements. If so, I just recently found two codes from different forums that brings up a "Search for/Replace" text box so that you can manually enter what you want to Search for and Replace.

Cited External Link1 Here

Please Login or Register  to view this content.

Cited External Link2 Here

Please Login or Register  to view this content.

However, if you know exactly what you want to replace text with for all 7 texts. Then you can restructure this:

Please Login or Register  to view this content.

I also tried this one out but didn't work...

Please Login or Register  to view this content.

Ok, I did some searching and found someone who declared a similar issue in regards to utilizing a Worksheet to define the "Find" & "Replace" info:

For example:

Cells A2 to A48 in workbook1 contains a list of many different values (Peugeot, Alfa Romeo, Ford, Renault etc...) and in cells B2 to B48 are their corresponding decimal values that need to replace them in another workbook (workbook2).

In Column A of workbook2 has thousands of instances of the values present in A2 to A48 of workbook1. The numeric values from B2 to B48 (lets say ford = 0.1 and peugeot = -0.4) need to replace the original text data in column A of workbook 2. (so 0.1 replaces ford and -0.4 replaces peugeot) - Macros/VBA Code for repetitive 'find and replace'

There are 4 pages of comments, so I will only re-post the code that was suggested, and follow the MsgBox instructions:

Please Login or Register  to view this content.

Ok, I had some time on my hands, download the documents and open VBA.xlsm to try this code:

• VBA.xlsm = VBA Macro/Run This!
• test.xlsm = Find & Replace List
• testo.xlsx = Data document that needs replacement

Please Login or Register  to view this content.

Sometimes I read to quickly and need to revisit the details, I hope this helps and if it isn't I'll go over it again.