Hi Jules

http://www.mvps.org/dmcritchie/excel/getstarted.htm
See David McRitchie's site if you just started with VBA

--
Regards Ron de Bruin
http://www.rondebruin.nl



"jules" wrote in message ...
Good morning. I just have one other thing to ask you - what do i do with the
formula you wrote? It looks like ancient greek!!

"jules" wrote:

Thank you very much for your prompt reply.
Best wishes
Jules

"Ron de Bruin" wrote:

Hi Jules

http://www.rondebruin.nl/copy5.htm

For a Add-in solution see
http://www.rondebruin.nl/easyfilter.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"jules" wrote in message ...
I have created a price list and would like to generate an order form from
that liston a separate worksheet. Is there a way of copying an entire row if
the column has a figure in the total column? The rows with a 0 total would
not need to be copied
Thank you