Results 1 to 4 of 4

FILTER - how to save filtered records to new CSV file

Threaded View

  1. #1
    Registered User
    Join Date
    07-20-2022
    Location
    New York, USA
    MS-Off Ver
    Home & Student 2019
    Posts
    13

    FILTER - how to save filtered records to new CSV file

    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!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Filter Data Based on Unique Column Items and Save the Workbook with Filtered Items
    By IonutC in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-18-2019, 03:08 AM
  2. VBA scrip to filter spreadsheet, save filtered data and email as attachment
    By Djxela in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-14-2019, 03:57 AM
  3. [SOLVED] Can't filter "Unique" records from Filtered range
    By Ochimus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-18-2018, 04:10 PM
  4. Want to open file, copy filtered data to new workbook and at save as new file
    By satishdu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-25-2014, 12:39 PM
  5. Need QueryTable to filter records imported from csv file on certain condition
    By husein_786 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-11-2013, 05:01 PM
  6. [SOLVED] save an excel file in fixed length records whose fields are blank
    By ascii save in forum Excel General
    Replies: 1
    Last Post: 10-13-2005, 01:05 PM
  7. Copy records that have a certain date - then save as file.
    By peabrain999 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-09-2005, 02:13 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1