Re: $$Excel-Macros$$ Cell entry activates code to move line to diff tab

ts("Active").Select >     Selection.Delete Shift:=xlUp >     Cells(Selection.Row, 3).Select >     MsgBox "Task was moved to completed tab" > End Sub > > > From: DEF > To: MS EXCEL AND VBA MACROS > Sent: Fri, June 25, 20

Re: $$Excel-Macros$$ Cell entry activates code to move line to diff tab

xlDown     Sheets("Active").Select     Selection.Delete Shift:=xlUp     Cells(Selection.Row, 3).Select     MsgBox "Task was moved to completed tab" End Sub ____________ From: DEF To: MS EXCEL AND VBA MACROS Sent: Fri, June 25, 2010 12:38:45 PM Subject:

$$Excel-Macros$$ Cell entry activates code to move line to diff tab

So I have a file where a task/person responsible etc. is listed When the task is completed, I would like to enter yes and upon this text entry, the file would delete that line and add it to another tab with other completed tasks. I need other entries of text to have nothing done. Task Person Com