Forum Discussion
Multiple replace vba
Thanks for the reply but I don't understand how it works. the macro fills in the correct version column but does not replace errors. the file was just an example as my database is made up of names also composed of cities and relative altitude followed by "m" the errors are both in the name and in the altitude or the lack of "m" for ex new york city 10m, new york, new york city 10, new york 12m ...
The screenshot shows the result after running the macro. Does this return the expected result? In my understanding the errors are replaced in column D (besides avocado because that is missing in the database). I'm not sure what your actual file (database, error, test) looks like but if you want to replace any errors containing "new york" (in the error column) with for example "new york city 111m" (taken from the database column) then it should be possible to add that to the code.
I've just added a few lines to the code and the second screenshot shows the result for various errors that contain "new york" in the error column.