+ Reply to Thread
Results 1 to 7 of 7

Filter two column

  1. #1
    Forum Contributor
    Join Date
    09-14-2012
    Location
    mumbai,india
    MS-Off Ver
    Excel 2003
    Posts
    367

    Filter two column

    Hi everyone,
    Please Login or Register  to view this content.
    I am trying to filter two columns at once, but vba is not working properly, please help me.
    I will be very grateful if you help me..
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,525

    Re: Filter two column

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    09-14-2012
    Location
    mumbai,india
    MS-Off Ver
    Excel 2003
    Posts
    367

    Re: Filter two column

    jindon,
    Attachment 804849
    But it is still not filtering the column, on running vba code it is showing only empty column.

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,525

    Re: Filter two column

    then don't post your non working code, but just the data and the result that you want showing clear logic for filter.

  5. #5
    Forum Contributor
    Join Date
    09-14-2012
    Location
    mumbai,india
    MS-Off Ver
    Excel 2003
    Posts
    367

    Re: Filter two column

    I'm sorry I thought it would work when I run this code.Required Result.JPG
    Last edited by sanju2323; 11-14-2022 at 02:00 AM.

  6. #6
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,525

    Re: Filter two column

    You can not use Autofilter in "OR" condition with multiple columns.
    AdvancedFilter
    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    09-14-2012
    Location
    mumbai,india
    MS-Off Ver
    Excel 2003
    Posts
    367

    Re: Filter two column

    Thank you very much it is working well

+ 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. If a cell matches a name filter for this column if not then filter this column
    By wherdzik in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-14-2020, 11:52 PM
  2. VBA Advanced Filter - Two Filters Without Deleting Bottom Filter Data In Same Column Range
    By hysterical.useless in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-14-2017, 02:54 PM
  3. Undo a filter on a particular column, leaving the filter on another column
    By MissDB in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-06-2017, 11:50 AM
  4. Replies: 1
    Last Post: 12-12-2014, 06:46 AM
  5. Replies: 6
    Last Post: 10-16-2014, 08:42 AM
  6. Replies: 0
    Last Post: 01-16-2014, 10:55 AM
  7. Replies: 9
    Last Post: 01-04-2013, 09:56 AM

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