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

--
Message posted from http://www.ExcelForum.com

Why not use an if statement?

=IF(Sheet2!C1="YES",Sheet2!A1,""

--
Message posted from http://www.ExcelForum.com

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



"DNF Karran " pí¹e v diskusním
pøíspìvku ...
Why not use an if statement?

=IF(Sheet2!C1="YES",Sheet2!A1,"")


---
Message posted from http://www.ExcelForum.com/

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

--
Message posted from http://www.ExcelForum.com