The subject of this may be oversimplifying what I'm trying to do and have been trying to do for the last few months, at this point, my brain is fried and I need help.
I have two sheets, weekly and yearly.
On weekly, I have a to-do list and another section for tasks I'll do next week.
On yearly, I have a list of tasks I need to accomplish throughout the year.
What I'm trying to do is the following in this order:
1) At the end of the week, I want to clear the accomplished tasks (I got this part working, tasks that are completed have the date they were accomplished marked in the gray box on the bottom right and their task box is grayed out.)
2) I want to move the remaining tasks to the top of the list (this was working, then my Excel updated and my code essentially started flipping me the bird.)
3) After the remaining tasks are moved up I want to grab the tasks in the yearly for that week and add them to the to-do list (for this, I reference the week number in the yearly with the week number I have set on the weekly, i.e. if the week number for that week matches the week number for that task copy/paste the task to the next blank cell in my to-do list. And because I print my planner out and make notes on my tasks, there are blank spaces between my tasks. You know just incase this was too easy to start with.)
4) and finally move the tasks in the next week section to the to-do list.
It sounds sooooo simple, right. Please for the love of whatever you believe in, help me!!!
Images are attached.
I have two sheets, weekly and yearly.
On weekly, I have a to-do list and another section for tasks I'll do next week.
On yearly, I have a list of tasks I need to accomplish throughout the year.
What I'm trying to do is the following in this order:
1) At the end of the week, I want to clear the accomplished tasks (I got this part working, tasks that are completed have the date they were accomplished marked in the gray box on the bottom right and their task box is grayed out.)
2) I want to move the remaining tasks to the top of the list (this was working, then my Excel updated and my code essentially started flipping me the bird.)
3) After the remaining tasks are moved up I want to grab the tasks in the yearly for that week and add them to the to-do list (for this, I reference the week number in the yearly with the week number I have set on the weekly, i.e. if the week number for that week matches the week number for that task copy/paste the task to the next blank cell in my to-do list. And because I print my planner out and make notes on my tasks, there are blank spaces between my tasks. You know just incase this was too easy to start with.)
4) and finally move the tasks in the next week section to the to-do list.
It sounds sooooo simple, right. Please for the love of whatever you believe in, help me!!!
Images are attached.
