Hey all,

Can anyone advise on how to use the if statement, or
another string of commands, on the following scenario:

A row contains relative data (10 cells worth). The final
cell will contain a "1" or "N/A". I would like to have a
macro locate all rows without the "1", cut it, and paste
it on the following sheet at the bottom of the sheet. It
will continually add lines to this new sheet (like a
completed order sheet for instance).

I'm not quite sure if this is explained correctly, so any
feedback would be great, and I can explain further if
necessary.

Thanks,
Andrew