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

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

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

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