Filtering Data

C

Chad

Hi All,

I am not sure how to attack this.

I am importing in a bunch of data from an Access Database Query. Now I need
to filter this data. I cannot use the autofilter because I need to save
only the filtered data so that another application can import it.

I am thinking the easiest way, would be to autofilter the data, copy it to
sheet2, delete sheet1, then save the data as a *.csv file (that is the
format I need in the end).

Does this seem logical, or is there a better way.

Thanks
Chad
 
D

Dave Peterson

That seems reasonable to me.

An alternative would be to filter the data to show the data you don't want.
Then delete those visible rows and save that workbook as your .csv file.
 
Top