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

G

Guest

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.
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to write value 1
Write record from Form to new row in spreadsheet 1
Lookup value, display multiple values in new worksheet 4
How do I get a formula in a cell to read from another cell 2
Removind diagonal lines created on sheet 6
How to read all lines from a text file into cells C10:Cxxx ? 1
Tracking Access in Read-Only Files 0
Copying template from one worksheet to another 2

Top