Automatically move a row in excel to a new worksheet when a date is entred

[EKG]

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

[dmcgov]

please post a sample workbook.

[EKG]

Please find an example of it attached - I have had to remove some of the data hope this is still ok to work from.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[EKG]

Hi John,
Thank you but that just seemed to change the cell with the date dark blue, but nothing moved.

[JOHN H. DAVIS]

Note last edit to post at 11:43.

[dmcgov]

working on a solution, maybe I'll beat John to the punch (lol, probally not).

[dmcgov]

ok, try this:

put this in the sheet code for tab "Destruction"

Please Login or Register  to view this content.

note the upper range of keycells

and put this in a module:

Please Login or Register  to view this content.

probably don't need the case statement, it's a holdover from my older code.

[EKG]

Thank you both for the help you are amazing.
dmcgov I went with Johns as it worked.

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback. Please review the Forum Rules below and mark this thread as SOLVED.

https://www.excelforum.com/forum-rul...rum-rules.html

[EKG]

I feel I need to apologise and clarify, when I said "dmcgov I went with Johns as it worked" that should have been I tried Johns and it worked so I kept it, I was not saying that dmcgov did not work.
I am so grateful for the work you both did.

Thank you