I have a worksheet with twelve columns and 200 rows of data.
If column A is NOTBLANK and Column J is NOT= 1, then I want to copy cells in
column A, B, C and D to another worksheet. All of these cells from the same
row. If either condition doesn't match, then skip to the next row. The result
would be a compact report of about 40 rows with entry in column A ,B, C and D.