transfer completed task to a different worksheet

Hi, guys.

Im still learning the basics of excel.. I currently work at a back office processing paperworks. And one of our main task is to send out emails to update the paperworks. We need to send out an email from the time got the email 4 days from the time of receiving ( aware date ) until we exhaust 3 attempts. If its possible I wanted that the tracker once I complete all the values on the row. It will be removed off the sheet and transferred to my second sheet which is sort of my archive. (Sheet 2 = ARCHIVE ) and hopefully it can detect that I will need to fill out everything before it automatically transferrs the completed data. Also I did set up the other cells that

IF F2 is empty then then you can't fill out or choose a drop down for the H2
If H2 is empty then you wont be able to fill out J2
And once you fill out J2 granting that from A2 up until I2 everything is fill out then it will automatically transfer all the data to ARCHIVE

And also sorry if this is a stupid question but how do you remove the default results of a formula? I cant seem to remove the result of my formula when I set it up. It always has the result of 0-JAN-00 if there is no value on the other reference cells. I wanted it that it will be empty if there is no value on the reference cells


Thank you so much for helping out everyone.

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and click "manage attachments" to open the upload window.


To add a file to a post