I need a macro that will look at a range of values (e.g. G3:G200) and delete the value that matches the value in cell G2. I then want the macro to delete the empty cell by shifting all cells in the range up one.
All this action needs to only happen in column G. I don't need any other data deleted.
TIA!!
All this action needs to only happen in column G. I don't need any other data deleted.
TIA!!