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?
|