I'm finally admitting defeat with this one after spending hours searching and attempting to build.
I need a macro that will do the following can anyone help?
1) Select only cells within a specific column that
contain an entry
(The specific columns are C H M R W AB AG AL)
2) With only those cells with data selected
I want excel to then include in that selection the 2 cells to the left of the original selected cell and the 1 cell to the
3) I need to move that data to the first available cell in column AT.
4) Go back to where the original data was and shift those four empty cells up with out deleting the row
Many thanks to anyone who can help.