View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Abnormal "IF" request

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