I try to copy a row from sheet1 to sheet2 base on answer on 'Y' or 'N' .
it does nt work so far. I appreciate suggestion on other way to do this or modification of these code. I am urgent need.
thanks.
Sub COPY_TRUE()
Worksheets("Sheet1").Row().Copy _
Destination:=Worksheets("Sheet2").Row(7)
End Sub
Sub COPY_FALSE()
Worksheets("Sheet1").Row().Copy _
Destination:=Worksheets("Sheet3").Row(7)
End Sub
Bookmarks