Is there a formula that'll help manage my to-do list?
I keep an agenda at work to manage my ongoing tasks with upcoming deadlines. The agenda is on the left portion of the sheet, and the done pile is adjacent to it on the same sheet.
When I complete a task, I cut and paste it to the done pile.
But then I'd need to shift up the cells that are below it.
I just feel like there must be a formula that'd automate this.
For example:
Column A-D = ongoing tasks
Column F-I = done pile
Cell A2-D2: Watermelon
Cell A3-D3: Monster
Cell A4-D4: Thugs
...
"Monster" task is completed.
Cut cell A3-D3 and paste it into the done pile.
Select cells A4-D4 and all cells below and shift up to fill the blank.
Is there a formula that can...
Move a line of cells to a different area of the sheet?
Shift up all cells from below to fill the newly blank cells?
[link] [comments]
Want to read more?
Check out the full article on the original site