Moving Completed Task onto separate excel sheet?

[Lucy_Wood]

I am creating a to-do list for my job. I have two sheets

'Open Tasks' and 'Compleated Tasks'

I'd like the rows with tasks once marked 'Compleated' on Open Tasks, to move automatically to the Compleated Tasks tab.

From what I've read on other threads, I think this requires VBA and as I have absolutely no knowledge of VBA, I was wondering if someone could help me with this?

TIA

 

[Fluff]

Please start a thread of you own, for the question. Thanks

 

[Excel Curious 2023]

Try this:
This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab named Open Tasks
Select View Code from the pop-up context menu
Paste the code in the VBA edit window

When you enter Completed in any cell in column E the script will run
You said move so this script copies the row to other sheet.
You did not say delete row from existing sheet. If you want that you will have to say so.

Private Sub Worksheet_Change(ByVal Target As Range)
'Modified 2/21/2020 9:01:00 AM EST
If Target.Column = 5 Then
If Target.Cells.CountLarge > 1 Or IsEmpty(Target) Then Exit Sub
Dim Lastrow As Long
Dim SheetName As String
SheetName = "Completed Task"
Dim SearchValue As String
SearchValue = "Completed"
If Target.Value = SearchValue Then
Lastrow = Sheets(SheetName).Cells(Rows.Count, 5).End(xlUp).Row + 1
Rows(Target.Row).Copy Sheets(SheetName).Rows(Lastrow)
End If
End If
End Sub

Hi - if you do this and it copies it to the next worksheet, which it does, but then for some reason I need to change the status back to 'in progress' can it be done so that it automatically removes it from the worksheet it copied it to pls?

 

[My Aswer Is This]

Hi - if you do this and it copies it to the next worksheet, which it does, but then for some reason I need to change the status back to 'in progress' can it be done so that it automatically removes it from the worksheet it copied it to pls?

You need to start a new posting and explain in detail what you're attempting to do.