copy rows to new sheet based on specific cell value

[dlballard]

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.

 

[Ron de Bruin]

Hi dlballard

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

 

[dlballard]

Hi Ron,

Thanks - this is a bit outside my normal use of excel, but I'm determined!
I've had a quick read through the information and it seems to be just what
I'm looking for. The steps are detailed and clear, so I should be ok - it
may take some time due to my lack of experience with macros, but the time
it'll save me later will be well worth any time spent now. I'll let you know
how it works out.

Thanks again,

dlballard

 

[dlballard]

Hi Ron,

Just wanted to let you know that your suggestion worked like a charm! It
took me a bit of time, but now it does exactly what I was looking for. Thank
you so much!

dani

 

[Ron de Bruin]

Hi Dani

Thanks for the feedback

Have fun with Excel VBA

--

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