How to create a Macro to Copy Information in one sheet to another sheet.

  • Thread starter Thread starter poppy
  • Start date Start date
P

poppy

Hi All

I was wondering how I can create a Macro to copy information that is o
Sheet1 to SHeet2. The kink is that it only should copy the informatio
in Column A when for example column C has a cell in it saying "YES"
Please let me know at your earliest convience.

Thank You
 
or to write code on Sheet1

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Column = 1 And Cells(Target.Row, 3) = "Yes" Then
Worksheets("Sheet2").Range(Target.Address).Value = Target.Value
Else
End If

End Sub

MiRa
 
Hi MiRa


I get this error: 424 Object Required and it selects this line


Code
-------------------
If Target.Column = 1 And Cells(Target.Row, 3) = "YES" Then

-------------------


Any idea what is wrong?

Kind Regard
 
Back
Top