Perhaps you might want to try this recent thread (similar query)
with responses for 2 approaches:

http://tinyurl.com/ddo6m

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"opshmo" wrote in
message ...

HELP NEEDED.
I am trying to create a spreadsheet to keep track of problems that we
encounter at our volunteer organization.
It is pretty simple.
I am having one problem. One of my fields is "completion information."
What I need is when completion information is entered into the field, I
want that line of information to move to an "archived sheet".
In effect, so that I have a sheet with only active problems and when
the completion information is entered it moves to the archived sheet.
Anyone have any suggestions?


--
opshmo
------------------------------------------------------------------------
opshmo's Profile:
http://www.excelforum.com/member.php...o&userid=27862
View this thread: http://www.excelforum.com/showthread...hreadid=473668