Formual that removes a task from one sheet and places it on another sheet

[cmorten82]

Not sure if this is a VBA question or a formula question. I am looking at a task list on sheet 1 that once a task is marked completed it removes that task from the list and places it on sheet 2. so cell A1 would have a drop down with in progress and completed A2 would have a task and if I choose completed it removes that task and places it on sheet 2 and then moves the next task up.

[TMS]

A formula can't do that. You'd need VBA. But why bother? Why not just keep all the data on the one sheet? Convert the data to a Structured Table and get built in filtering and sorting. Using the filters, you can look at just the completed entries, or the uncompleted entries. But, better, you can mix and match. So, for example, you could filter by date and see all tasks for a day, month, year, whatever. And, if everything is on the same sheet, you can do more comprehensive analyses using Pivot Tables and Charts. And you can calculate percentages, say, of completed versus total tasks, etc. Much more difficult if you are splitting the data across sheets, especially if you are dependent on running a macro before undertaking the analysis.

Regards, TMS