Does anybody know how to create a macro that will search on sheet1 starting in row 2 searching Column G. It will check to see if the cell is empty and if it is it will move that entire row to the Sheet called Empty. It will then delete that row in Sheet 1 and move everything up and check row 2 again that should have new information since the previous row 2 was moved to another sheet. If the cell in column G is not empty it will move the entire row to the Sheet called Info. This macro would need to run until Column A has an empty cell. Any help is greatly appreciated.