Hi dlballard

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"dlballard" wrote in message ...
Is it possible to copy an entire row to a new workbook based on a specific
cell's value? Specifically, if the cell contains a "1" I would like the
entire row to be copied to a new workbook. I know this can be done manually
by sorting, copying and pasting, but the file is large and there are a few
hundred rows that meet the criteria weekly. Any help is appreciated - it now
takes a considerable amount of time to do this.