VBA macro to automatically copy whole row to another sheet based on cell value

[Heracek]

Hello, I would like to ask for a help creating a VBA macro that will automatically copy the whole row when value is entered into a certain cell.

I am on Windows 10, Excel 365 version.

Here is what I am working with, when a date (the script could check for any value but a date will be entered here) is entered in column C and cell C3 onward in sheet 2 (2022) I need the row to be copied over to sheet 1 (Pece):

I tried to copy and edit various macros I found online but I failed to make any of them work.

Thanks in advance!

 

[Joe4]

Welcome to the Board!

Right-click on the sheet name tab at the bottom of your "2022" sheet, select "View Code", and paste this VBA code to the VB Editow window that pops up:

Private Sub Worksheet_Change(ByVal Target As Range)

'   Exit sub if multiple cells updated at once
    If Target.CountLarge > 1 Then Exit Sub

'   Check to see if column C after row 2 updated
    If Target.Column = 3 And Target.Row > 2 Then
'       See if a date is entered in column C
        If IsDate(Target) And Target > 0 Then
'           Copy row to bottom of Pece sheet
            Rows(Target.Row).Copy Sheets("Pece").Cells(Rows.Count, "A").End(xlUp).Offset(1, 0)
        End If
    End If

End Sub

This will automatically copy the row to the "Pece" sheet when a valid date is manually entered into column C of the "2022" sheet.

 

[Joe4]

So, does that work for you?

 

[Heracek]

Thanks! It does work in the most basic way that I requested and if you don't mind I will have some questions or request for adjustments later, when I can get back to it.