Copy the entire row in New workbook

[laku0006]

Hello,

Can any one help me create a macro, Let me tell you what am looking for,
I have a worksheet which is regularly updated as Research complete or Complete Research in the F column, what I want is to copy the entire row when ever the F column is updated and paste the Entire row in to another worksheet calls Master.

can anyone help me on this. If anyone has questions can reply me.

Appreciate your help in this regard.

Thanks.

 

[jim may]

How is your Column F populated?

Is there any way it (Col F) could get populated with the intended Research Complete or Complete Research and not receive either of these 2 exact phrases?

 

[laku0006]

Yes, it has a Validation list, which has Research Complete and Pending Research, below is the code which I have, but this works with in the same workbook, but I want to paste the details in a new workbook, which i have named as Master.

This is working in the same sheet but i want to paste in a new workbook.

Private Sub WorkSheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Column <> 9 Then Exit Sub
If Target = "Pending" Or Target = "Complete" Then
Sheets("Master").Cells(Rows.Count, "A").End(xlUp).Offset(1).Resize(, 9) = Target.Offset(, -8).Resize(, 9).Value
End If
End Sub

Please help.

Thanks
Lav...