| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter External data
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PivotTable Date Filter External Value | Excel Discussion (Misc queries) | |||
| Filter External Data | Excel Discussion (Misc queries) | |||
| Filter external data | Excel Discussion (Misc queries) | |||
| Automatic filter during import of external data? | Excel Discussion (Misc queries) | |||
| Set external cell filter for a range | Excel Discussion (Misc queries) | |||
Linear Mode
