Filter External data

H

hmm

I have connected an Excel 2007 worksheet with an external text file. The
text file contains extraneous lines of data that I'd like to filter on
importing (as opposed to a workbook filter, which will not filter the rows
out of calculations). The extraneous lines contain only 2 comma-separated
fields each, while the lines of interest contain many more.

How can I specify to import only the lines of interest when refreshing?
 

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

Using Auto filtered Data 0
filter result- total row numbers varies 1
import external data as a List (not table) into excel 2010 with excel 2000-2003 list format 0
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
external data table sort order 0
Excel file linked to external source 0
Comparing columns of data? 0
Query via Import External Data doesn't reflect revised syntax 0

Top