| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filtering Text File Import
Excel 2000
I'm at an early stage in developing a model whereby I want to import a CSV file but only where the first element of the record matches a criteria. I'm thinking of having a drop down list on a worksheet which shows the possible options; would like to draw this list from the CSV file if possible, I would then click a button on the same sheet that imports into a new file the records that match the criteria. VBA to open / import a CSV file I'm okay with but how to filter into a drop down list and then only open the chosen matching records is beyond me. Any pointers most welcome.... Rob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I import text file of cash flow to excel file then use formula | Excel Discussion (Misc queries) | |||
| Set Defaults in File Import of a Text File | Excel Worksheet Functions | |||
| Would Like to Automate Batch File Creation and Text FIle Import | Excel Discussion (Misc queries) | |||
| import text file | Excel Programming | |||
| Get External Data, Import Text File, File name problem | Excel Programming | |||
Hybrid Mode
