Copy data from one work sheet to another

[kiwikiki718]

Hello how do I copy data from one work sheet to another based on a condition?

Ex. If worksheet 2 cell C3 = True, I want to copy data from worksheet 1 cells A3,A4,B3,B4 to worksheet 2 cells A3,A4,B3,B4. If the data is blank in worksheet 1 I want the data to also show blank in work sheet 2.

Note cell C3 is a checkbox

Thanks in advance

 

[ACommandLineKindaGuy]

I'm assuming C3's value is the state of the checkbox. This goes in Worksheet 2

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = Range("C3").Address Then
    If Target = True Then
        Worksheets(1).Range("A3:B4").Copy
        Range("A3:B4").PasteSpecial xlPasteAll
    End If
End If

End Sub

 

[kiwikiki718]

I'm assuming C3's value is the state of the checkbox. This goes in Worksheet 2

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = Range("C3").Address Then
    If Target = True Then
        Worksheets(1).Range("A3:B4").Copy
        Range("A3:B4").PasteSpecial xlPasteAll
    End If
End If

End Sub

Thank you this worked.