I need help writing a Macro which will move data from a cell to an adjacent cell.
E.g
Column B has only data in certain cells, I would like the Macro to work down the column and every time it encounters data in Column B to move it into the adjacent cell into Column A.
Thanking you in advance for your assistance
E.g
Column B has only data in certain cells, I would like the Macro to work down the column and every time it encounters data in Column B to move it into the adjacent cell into Column A.
Thanking you in advance for your assistance