I am preparing a to do list in which there is Status (completed / not yet) and Task name in sheet 1. In sheet 2 (completed) the task which is marked completed is moved with the current time.
Now I need to work out on adding two more columns D (person) and E (estimated completion date) in Sheet 1. So, When I mark the task as Completed & click on button, all 3 details i.e. Task name, Person and Estimated completion date should move to Sheet 2.
For the reference, I have added the file here. Macro codes are defined.
I am unable to edit the code as per above requirement.
Any help would be greatly appreciated.
Now I need to work out on adding two more columns D (person) and E (estimated completion date) in Sheet 1. So, When I mark the task as Completed & click on button, all 3 details i.e. Task name, Person and Estimated completion date should move to Sheet 2.
For the reference, I have added the file here. Macro codes are defined.
I am unable to edit the code as per above requirement.
Any help would be greatly appreciated.
Comment