Moving complete rows of data from one sheet to a new sheet when a date is entered

Hi everyone,

I have been searching through the forum for a while and havent quite found the answer to my problem. I have a spreadsheet with lots of data, I am trying to manage this data a little better. I would like to find a way to move a row of data to a new sheet inside the workbook when a date is entered into column S. I would then like the row that was moved to be deleted from the first sheet. Can anyone help with this issue?

Maybe:

Please Login or Register  to view this content.

Assumes that the Sheet "new sheet" is already created.