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

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
 
M

MiRa

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
 
P

poppy

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top