Help with filtered save

  • Thread starter Thread starter Glen Mettler
  • Start date Start date
G

Glen Mettler

I have a worksheet that contains data coded into 2 categories - BTP & NDP.

I want to save the worksheet as a CSV with only the BTP data.
I have a macro that filters the data and then saves the sheet as a CSV.
However, when I look at the CSV file all rows are there not just the
filtered ones.

Is it possible to save only filtered data?

Glen
 
Hi Glen,

Either delete the NDP data or copy the BTP data to another sheet,
 
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

SUMMING TOTALS BASING ON CHARATERS ENTERED IN CELLS OF ONE COLUMN 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Saving worksheet as CSV with correct usedrange... 1
copy and save as csv 4
Want Macro to save to .xlsx 2
Which is the best MBOX Converter Tool different formats conversion? 4
Push data from Excel to SQL Server 2
Rows outside of current range being saved as CSV 2

Back
Top