Hello,
I need to write a VBA macro that will change the text of a cell based on the value already in the cell. For example, the cell can be anywhere in Column A and if the cell value equals "Jones1413" I want to change the text of that cell to "BJones". The rows of data can change and the value will not be in the same cell every time the report is ran.
I need to write a VBA macro that will change the text of a cell based on the value already in the cell. For example, the cell can be anywhere in Column A and if the cell value equals "Jones1413" I want to change the text of that cell to "BJones". The rows of data can change and the value will not be in the same cell every time the report is ran.