1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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...

  1. Move a line of cells to a different area of the sheet?

  2. Shift up all cells from below to fill the newly blank cells?

submitted by /u/--hoodie
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#AI formula generation techniques
#formula generator
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#financial modeling with spreadsheets
#Excel alternatives
#to-do list
#agenda
#formula
#excel
#tasks
#deadlines
#sheet
#cells
#cut and paste
#shift up
#automate