Macro for massive search-replace by coolumns

Rather than use VBA and, potentially corrupt the original data (unknowingly) if the data is changed out of sequence, why not have a separate (copy) sheet and use VLOOKUP with the conversion tables you have to change the values? You retain the original data but can analyse the data on the copy sheet.

Hum yea I see.
That would be a bit longer to do, but indeed, its safe. I fear I could have errors though, because they might be empty cells in columns, and that file is so heavy

Easier and safer to try it first without VBA. You could do a column at a time and Copy and Paste Special | Values to get rid of the formulae and the performance overhead. When it's all converted, you could copy, or move, the new sheet to a new workbook so you could analyse the data without having two copies present.

Just a thought

If you did want to use VBA and do one column at a time, you could adapt this code.

Please Login or Register  to view this content.

Of course, make a copy of the workbook before you destroy/edit it

The VBA option should be quite fast. Make a copy of your workbook and try it.