Without using VBA it is difficult to selectively copy.
Here is a suggestion:
In A1 of Sheet2 enter: =OR(ISBLANK(Sheet1!A1),Sheet1!J1<1)
In B1 of Sheet2 enter: =Sheet1!B1; copy this over to C and D
Copy the four formulas down 200 rows
Now in A, the ones you do not want have the value TRUE
Select everything on Sheet2 and sort by Column A
Delete the rows with TRUE in A
Delete or clear column A
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"AM" wrote in message
...
I have one sheet with Twelve columns X 200 rows of data.
I want to check values in column A and Column J. If column A is (not
blank)
and column J has a 1 [numeric value], then I want columns B, C, and D in
the
same row copied to another sheet.