| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I have a read only xl file, I need it to be read and write | Excel Discussion (Misc queries) | |||
| Read-write/Read-only | Excel Discussion (Misc queries) | |||
| How can a file be converted from Read-Only to Read/Write | Excel Discussion (Misc queries) | |||
| select lines from multiple worksheets and write to new worksheet | Excel Worksheet Functions | |||
| How do I have a IF AND formula read 2 different cells to be true | Excel Worksheet Functions | |||
Linear Mode
