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.