Hi,

I am hoping someone could help me.

I have a couple of spread sheets where I would like the entire row to move to a new worksheet when I entre the completion date (or just yes if date is not possible) making one worksheet the active and one completed.
I would the row to go to the top of the new worksheet so the most resent is always at the top.

I have tried to edit some of the codes posted before but none are working for me.

I have content in columns A-M but L is where the completion date is. I have conditional formatting (colour changes) on the first worksheet but I do not need this on the "completed" worksheet.

I would be extremely grateful for any help.

Thank you in advance

EKG