Find and replace in several (not all) sheets

Hello there,

I need to find a quick/automatic way to execute a ca. 500 "find and replace" 's in more than 250 sheets.

I prepared an excel file for a better understanding of the problem that I attach here.
-sheet "list of substitutions" is where the values to be found/substituted and the replacement values are (column C and D)
-sheet File 1 Microsoft is a raw example of how one of the 250 sheets are.
-sheet File 1 Microsoft (corrected) is how the above should become.

Any ideas?

Much appreciated.

Blackberry2012

Hi there,

Take a look at the attached workbook and see if it does what you need.

Click on the "List All Worksheets" button - this will create a table containing the names of all of the worksheets in the workbook. Then delete from this list the names of those worksheets on which you do NOT want Find And Replace operations performed.

Then click on the "Find And Replace" button.


The replacement value tables are divided into two types: Letter Case correction (for which only the final value need be specified) and Word correction (for which the initial and final values need be specified).


The workbook uses the following code:

Please Login or Register  to view this content.

The highlighted value may be changed to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

Thank you both! In the end both coding were precisely what I needed.

Much a appreciated.

Hi again,

Many thanks for your feedback.

You're welcome - glad I was able to help.

Regards,

Greg M