In Excel, I would like to create some type of code that automatically cuts a row of data from one worksheet, “Open Records”, to another worksheet, “Closed Records”, in the same work book.
For example, a record is entered with a corresponding date. Possibly a week later or more, additional data is entered and a closing date is entered.
I would like to automate that when the closing date is entered, the row is automatically cut and pasted to a “Completed Worksheet”.
Please Help! Thank You!
