Read lines from one worksheet, if value is true, write to new work

B

Bernie

I have a workbook, with a worksheet that has 2000+ entries. I need to search
column AF, if the value = what I'm looking for, then write that entire line
to a new work sheet. Any help/guidence would be greatly appreciated.
 
W

Wood Grafing

Need more details:

Provide an example of what you're looking for, and is it going to a certain
location in the new sheet?
 
D

Dave Peterson

How about applying Data|Filter|Autofilter to column AF. Then filter to show
what you want.

Then copy those visible rows to the other sheet.

If you need a macro, you could record one when you do it manually.
 
Top