I am a bit new to VBA and I need a start.
I want a macro in excel that renames cells if a certain criteria is met, loops through all rows in column A and renames those cells.
So if I have the criterias
I want that cells containing test will be renamed to else
I want tjat test2 will be renamed to somethingelse
I want that test3 will be renamed to evensomethingelse.
and so on and so on so I can add some criterias and have those renamed as I want.