Transfer data back and forth between sheets

[Psycho Monkey]

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?

 

[akphidelt]

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.

 

[TomPl]

Have you considered <Data><Autofilter>? You could include a column to
indicate whether the item is done or not done, then you could filter on that
column.

Tom