DaveMy1978
New Member
- Joined
- Jul 1, 2022
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Good Afternoon All,
Hoping someone can help me.
I am working on setting up a simple Task List for a small group of people and would like to be able to 'assign' the task to the individuals task list.
The attached image shows the basic layout.
In essence I would like to go through the task list once a week, and assign a task to an 'owner' then once all tasks have been assigned, I can click the 'Assign Tasks' button, and the VBA will cut the row, and paste the row into the relevant persons Task List, i.e. all tasks for Dave go to Dave's list etc etc.
(I have managed to sort out the archive tasks at Least but my VBA skills are very much basic, and I'm struggling with last bit)
Any help would be most appreciated.
Hoping someone can help me.
I am working on setting up a simple Task List for a small group of people and would like to be able to 'assign' the task to the individuals task list.
The attached image shows the basic layout.
In essence I would like to go through the task list once a week, and assign a task to an 'owner' then once all tasks have been assigned, I can click the 'Assign Tasks' button, and the VBA will cut the row, and paste the row into the relevant persons Task List, i.e. all tasks for Dave go to Dave's list etc etc.
(I have managed to sort out the archive tasks at Least but my VBA skills are very much basic, and I'm struggling with last bit)
Any help would be most appreciated.