Filtering Data

  • Thread starter Thread starter Chad
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

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

remembering the same filtering criteria 13
Using Filter List to set Chart Symbol, data labels etc 1
Copy Paste with fiter and hide copies filtered and hidden 0
AutoFilter Slow problem 1
Copy Paste all data tough filtered 3
another filtering question 1
Autofilter problem 7
Please explain this AutoFilter procedure 6

Back
Top