I am new to VBA and need a code for the following. I am trying to search a column for empty cells. if it is empty then i want the row below it to move up and occupy the empty space but not the entire row to move up. more like 5 colums around the empty cell to move Is it possible?
I have attached the file as an example. kindly help me.
Bookmarks