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
|