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

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.

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

Need more details:

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

"Bernie" wrote:

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.

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

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.

Bernie wrote:

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.

--

Dave Peterson