Moving a line of data when information is entered in a specific cell.

[opshmo]

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?

 

[Max]

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

http://tinyurl.com/ddo6m

 

[JR]

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"