Move entire row to another sheet and deleting the old row only.
 

I have a workbook that has three sheets. One(Sheet1) that has the active
projects, Sheet2 that contains the completed and/or cancelled projects, and
sheet3 that has menu seletions for the cells in sheet 1 that has a data
validation in them. They are also sheet protected ("PROTECT").

I have conditional formating on sheet1 that when the cell of column AZ="X" &
BJ!="X" it turns the entire row gray when the project is completed, and
another that when cell of column BJ="X" & AZ!="X" will change the text to
lineout if the project is cancelled.

I would like to run a VB program that will run every night around 23:00 that
will move the entire rows of completed or cancelled projects to the next
available row in Sheet2. Then delete in sheet1 the entire rows (A:ZZ) only
of the ones that were moved.

if not have a program (control Button) that when selected will run the macro.


Best Regards,
Dave