How to automatically move a row onto a new worksheet

Hi everyone, I'm really sorry if this is really obvious, I'm a newbie when it comes to Excel formula/VBA and have overestimated the ease I can do things! (I'm at the level where I can sometimes understand what I'm reading and occasionally know where I need to go to do what but that's it I'm afraid!)

I am currently redesigning our spreadsheet that we log our contracts on and their progress. I would like to have a code that when I input a date into column AF on Worksheet 1 it will copy that whole row into Worksheet 2 and delete the row on Worksheet 1. I've seen several different pieces of code and I'm really confused as to what I need to definitely have and what I would need to amend etc. I know everyone codes differently so that would probably be why I have seen so many different forms, but it's definitely just confused me massively!

Thank you so much for any help you can give me!

Hi JMor, Unless one of the many advanced users here can give you something specific, what I would do is record a macro. Set up your scenario by opening both spreadsheets and first making sure the name and tabs are already setup on each sheet, including the information in sheet 1 that you will want to move to sheet 2. Then, using the macro recorder found in the lower left, record the steps. Input a date, press copy, go to the next sheet and paste, go back to sheet 1 and erase the row, etc. Stop the recorder when done by pressing it again. Now you have a "basic" script to work from. You can add other recording pieces to it and build what you need. This should work as long as the name of sheet 2 does not change. You can even add script to open sheet 2 using this method and adding it to your "main" script. Do you want it to perform this task at the push of a button, do you want it to perform this function when a date is entered, etc. Those can be added to it. If you need assistance, if possible, provide a sheet with what you have so we have something to work off of. Good luck.

Squeaky.