i am running excel 2007. i want to move any row that has a date entered in column "G" to

i am running excel 2007. i want to move any row that has a date entered in column "G" to sheet 2 (with cell formatting), and then remove the row from sheet 1.

It's hard to write a code for this without seeing the data, so I am going to make a few assumptions and can change the code based on your comments. I am assuming your column that contains dates start in G1 on Sheet1 and you are copying the data onto sheet2 starting in row 1. I am also assuming that if there is not a date in column G, then the cell is blank. Finally, I am assuming that column F on Sheet1 contains data in every row. If not, we'll have to change the code.

Please Login or Register  to view this content.