copy rows to new sheet based on specific cell value

  • Thread starter Thread starter dlballard
  • Start date Start date
D

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.
 
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
 
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
 
Back
Top