Automatically moving row of data to another sheet

[drscfc]

Hi all

Am learning as I go with excel and have found this forum very useful for some of my little queries about formulae without having to post but am a bit stuck on what I want to do next.

I have a 2 worksheets set up - "Weekly Detentions" and "Archived detentions", Weekly detention is the sheet in which data is input. Columns A-N contain various drop down lists and one macro in column E. What I would like to happen is that when someone inputs a "y" in column L, the whole row of data is removed and put into "Archived Detentions" so that it forms a list of all the detentions that have been sat and the Weekly Detentions only contains those detentions that are yet to be sat.

Is this possible?

Any help would be hugely appreciated. Thanks.

 

[drscfc]

Tried both suggestions and still no luck I'm afraid. The macro for row E (automatic date input) is still no longer working and nothing happens when y is put into column L.

 

[venkat1926]

I think there is communication gap. post a very small extract of your file with some macro you are taling about row E and also my macro . I think the configuration we were visualising is different from yours.

 

[tablecloth]

thanks for this information.