Moving Rows with a certain color to a new sheet

[Michelle Hillard]

Hi guys,
I have 2 sheets in a workbook.
1 called Tasks, the other called Archived Tasks
Tasks contains current tasks and has 3 columns: 'Task','Details', and
'Done'.
When I type in 'y' in the 'Done' column, I would like this row to be
highlighted green, and then automatically moved from the Tasks sheet to the
end (appended to exisiting archived rows) of the Arhived Tasks sheet.
Any help would be greatly appreciated.

--


---------------------------------------------------------------------
"Are you still wasting your time with spam?...
There is a solution!"

Protected by GIANT Company's Spam Inspector
The most powerful anti-spam software available.
http://mail.spaminspector.com

 

[Tom Ogilvy]

Believe JE McGimsey gave you some code to do this at one of your multiposts
of this question.