+ Reply to Thread
Results 1 to 3 of 3

Filter Data Based on Unique Column Items and Save the Workbook with Filtered Items

  1. #1
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486

    Filter Data Based on Unique Column Items and Save the Workbook with Filtered Items

    Hi guys,

    Need some help. I have a workbook I have to filter based on column I. First I have to Make a Colection of Unique Items from col I, Filter the Workbook with each unique item and saved the filtered info of each unique item to a new workbook. What I need is to save only the filtered info. Currently it saves all the data with the filter.
    Please Login or Register  to view this content.
    Thank you!
    Last edited by IonutC; 06-18-2019 at 02:34 AM.
    Please consider:
    Be polite. Thank those who have helped you.
    Click the star icon in the lower left part of the contributor's post and add Reputation. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Posting code between tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

  2. #2
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Filter Data Based on Unique Column Items and Save the Workbook with Filtered Items

    Hi IonutC,
    maybe so
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486

    Re: Filter Data Based on Unique Column Items and Save the Workbook with Filtered Items

    I did it with
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Count Unique Items in a Column Based on Unique Items in Two Other Columns
    By HangMan in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-31-2015, 04:48 PM
  2. Pulling unique list based on items in first column
    By harryS81 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-07-2014, 05:18 AM
  3. [SOLVED] Display Items in Listbox based on filtered data
    By puuts in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-14-2014, 12:33 AM
  4. [SOLVED] VBA copies rows based on specific items in a column but need to rename items created
    By djfscouse in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-06-2013, 11:38 PM
  5. [SOLVED] How can I count unique items in a filtered column?
    By terry_believers in forum Excel General
    Replies: 11
    Last Post: 07-12-2012, 09:52 AM
  6. Macro to copy unique items, do sumif, vlookup, subtraction and then save data
    By excelaspire0219 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-18-2009, 03:56 PM
  7. Filter based on a column of items
    By Pasko1 in forum Excel General
    Replies: 1
    Last Post: 08-22-2005, 07:05 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