| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with filtered save
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with filtered save
Hi Glen,
Either delete the NDP data or copy the BTP data to another sheet, --- Regards, Norman "Glen Mettler" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return filtered values into report worksheet based on filtered valueon the data worksheet | Excel Worksheet Functions | |||
| save filtered results | Excel Discussion (Misc queries) | |||
| Help needed! - How do I save a filtered sheet? | Excel Discussion (Misc queries) | |||
| How do I save a filtered subset of a worksheet? | Excel Discussion (Misc queries) | |||
| traversing through a filtered range based on another filtered range | Excel Programming | |||
![Glen Mettler[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
