Moving Rows with a certain color to a new sheet

  • Thread starter Thread starter Michelle Hillard
  • Start date Start date
M

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
 
Believe JE McGimsey gave you some code to do this at one of your multiposts
of this question.
 
Back
Top