+ Reply to Thread
Results 1 to 3 of 3

Auto filter multiple columns matching with searched headers

  1. #1
    Registered User
    Join Date
    02-03-2011
    Location
    Bangalore
    MS-Off Ver
    Excel 2003
    Posts
    8

    Auto filter multiple columns matching with searched headers

    Simple one but tricky.. Help me in doing this:

    Lets say I have 6 columns out of 15 with part of the header text as "locale". Now I want the macro to find all those 6 columns by searching "locale" in row A1 for headers and filter the columns with 2 criteria (equals "en" OR "blank")

    For example sheet1 has:

    A1-Code1 A2-Bx Locale A3-Code2 A4-Locale
    B1-32432 B2-fr B3-435634 B4-ar
    C1-36546 C2-en C3-67854 C4-"blank"
    D1-65875 D2-"blank" D3-6532 D4-dh

    After the macro it has to be:

    A1-Code1 A2-Bx Locale A3-Code2 A4-Locale
    C1-36546 C2-en C3-67854 C4-"blank"
    D1-65875 D2-"blank" D3-6532 D4-dh


    Any code please....

    Thanks in advance...

  2. #2
    Registered User
    Join Date
    02-03-2011
    Location
    Bangalore
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Auto filter multiple columns matching with searched headers

    any coments?

  3. #3
    Registered User
    Join Date
    02-03-2011
    Location
    Bangalore
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Auto filter multiple columns matching with searched headers

    Any possible code help please??

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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