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

Hi
as a starting point have a look at
http://www.rondebruin.nl/copy5.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Andrew C" schrieb im Newsbeitrag
...
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

do a if statement next to the column you are looking at, if(a1=1,1,"") then create a macro that copies the new if statement that only has the 1's and paste special with values to the new sheet