VBA to move Table rows to another table based on date entry

[TestPilot87]

Looking for VBA to automatically move a row of data in a table to another table based on the entry of a completion date in a specific column. Help is appreciated.

 

[My Aswer Is This]

Re: Move rows between tables

I suggest you start a new posting for your question.
And explain in detail what your wanting and I will see if i can help you there. Do not say my question is the same as Autopilots.

Hi,
I have the same question as TestPilot87. I have Sheet1(IncompleteRequests) and Sheet2(CompletedRequests),
which contains the same number of column headers from A1 to E1.
The column names are PI (A1), Price (B1), Request type(C1), Organization (D1) and Date Completed (E1).
I will first fill out the next empty rows (for example range A2:D2) with relevant details, and will only fill out E2 as a date, such as 10/7/2018, once the request is completed.
I would like, upon filling out E2, for the information in A2:E2 to be transferred into Sheet2(CompletedRequests) and to be deleted from Sheet1(IncompleteRequests).

Would you kindly advise on how I may write such a macro?

Thank you.