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.