Results 1 to 3 of 3

Thread: Filtering Excel Data with VBA
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Oct 2014
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Filtering Excel Data with VBA

    Hi All,

    I have been searching the internet to solve my little problem.

    I have some data and I would like to filter in place unique data to show unique values only.

    I dont want to copy the data to another sheet as i will be using the filtered data to filter it down some more.

    So for example

    Name Last Place
    Ann A Wolves
    Ann b Bham
    Betty a Wolves
    Carol a Bham
    Carol b Wolves
    Ann A Wolves
    Carol a Bham
    So I need to filter on Wolves and show only the unique names.

    Thanks in advance guys.

    Moss

  2. #2
    Board Regular
    Join Date
    Dec 2009
    Posts
    288
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Filtering Excel Data with VBA

    If you research advanced filters, I think those will manage what you are looking for. In your example though, you would have to enter "Place" and "Wolves" into 2 cells of your sheet first, then use that for the criteria range argument of the advanced filter. I would try out the advanced filter through the Ribbon GUI first to see how it works before messing with the VBA.
    My favorite Excel Add-in:= Nutilities

  3. #3
    New Member
    Join Date
    Oct 2014
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Filtering Excel Data with VBA

    Quote Originally Posted by =ODIN= View Post
    If you research advanced filters, I think those will manage what you are looking for. In your example though, you would have to enter "Place" and "Wolves" into 2 cells of your sheet first, then use that for the criteria range argument of the advanced filter. I would try out the advanced filter through the Ribbon GUI first to see how it works before messing with the VBA.
    Thanks for your reply Odin.

    I think you have misunderstood me.

    When you do an advanced filter you can have the results displayed on the same page(inplace) which only shows the results or have the results copied to another sheet.

    I have tried mixing normal filter and advanced filter but some object error shows.

    The data also has other columns, which I guess play a part in the rows being unique or not.

    So i need to filter data based on the selection then show only the unique values where the values to use are in the first 3 columns only.

    Cheers all that have the knowledge.

    Moss

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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