I do not have knowledge of VBA. How tough are we talking?

"akphidelt" wrote:

Yes it is, but you will have to use VBA and come up with a code to do that.

Another way you can do it is to have a drop down data validation box in each
row. 2 Options... "To Do","Complete"

And then just filter that one column for To Do and Complete or create a
pivot table with the information also.

The way you are describing is the hardest way and requires VBA
understanding. If you have that understanding I can help you out with it.

"Psycho Monkey" wrote:

I would like to have a sheet with info on it and transfer it to another
sheet, adding it to the bottom of the list. Here is the master plan...
Let's call it a "To Do" list. When something on the to do list is done I
could use a drop down menu to say completed and the entire row would be
deleted from the to do list and transfered to the done list. That way there
is a rolling tally of what needs to be done and what has been done. Is this
possible?