Hi, first post.
Searched for, but did not find a solution to my problem.
I am making a Action List in sheet "ActionList", the list has 6 col:
No | Start date | Description | Link | Resposible | Finished
I am trying to make a macro that:
1 adds a new row below the last row
2 adds +1 to the number in the "No" col, starting at "001"
3 adds current date in "Start Date" col
4 and finally adds a button or check box in "Finished" col.
When clicking the box in "Finished" col, that row will be cut and pasted to a different sheet, "Finished", in the same workbook. All the finished items would also have to inserted below eachother in the order they were finished.
Is this doable?
Thanks in advance.
Searched for, but did not find a solution to my problem.
I am making a Action List in sheet "ActionList", the list has 6 col:
No | Start date | Description | Link | Resposible | Finished
I am trying to make a macro that:
1 adds a new row below the last row
2 adds +1 to the number in the "No" col, starting at "001"
3 adds current date in "Start Date" col
4 and finally adds a button or check box in "Finished" col.
When clicking the box in "Finished" col, that row will be cut and pasted to a different sheet, "Finished", in the same workbook. All the finished items would also have to inserted below eachother in the order they were finished.
Is this doable?
Thanks in advance.