You could...
1) Click the row number of a "completed" row to highlight the entire line,
then right click and "Cut". Go the archive tab, right click and "Insert Cut
Cells"
2) Right click a completed row number, then select "Hide"

"opshmo" wrote:


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