Transfer data back and forth between sheets
 

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?

Transfer data back and forth between sheets
 

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?

Transfer data back and forth between sheets
 

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

Transfer data back and forth between sheets
 

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?