When task is completed on first sheet, move to list on another sheet

[Auburn84]

Hey, all:

I have two projects that I'm working on that need the same kind of Excel function. Is there a way to set up a sort of "work flow" with Excel? I'm trying to see if I can set up two worksheets and once something is completed on the first (for instance, getting contact information for alumni), it moves to another list (some sort of "finished" list).

I'm a freelance writer trying to set up the same sort of thing for my projects. Active projects that I'm working on that move to a "done and paid" list once I've received payment. Right now, I'm manually moving things from one list to another. That may be how I have to do it, but I was wondering if there was a shortcut.

Thanks for any help!

Alec

[6StringJazzer]

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good titles. Your original title could have been the title for any thread. I have updated it for you this time because you are a new member. --6StringJazzer

[6StringJazzer]

This can be done, and may require VBA. However, your question is very generic. To give you a specific answer we would need to see your file.