View Single Post
  #1   Report Post  
opshmo
 
Posts: n/a
Default 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