In this example, I need to filter records in the last column (AK) by zero or one...easy. In small datasets, I can simply copy & paste the filtered dataset into a new workbook and save it as CSV (copy just the zeros in one workbook and the ones in a 2nd workbook). In large datasets (up to 60,000 rows) copy & pasting won't work. I've looked around for a solution to how to save the filtered set but haven't found anything yet. I'd appreciate any help you can offer. Thanks!
Bookmarks