+ Reply to Thread
Results 1 to 3 of 3

Combo Box to Filter by Merged Column Headers

  1. #1
    Forum Contributor
    Join Date
    02-23-2007
    Location
    England
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2208 Build 16.0.15601.20072) 64-bit
    Posts
    102

    Combo Box to Filter by Merged Column Headers

    Hello All

    Wishing you all a Prosperous New Year!

    I have a sheet attached which displays a list of company names as merged column headers. I have frozen the panes between E4 so the company header names and products in columns A:D are always visible upon scrolling. The company header names start at column E and go right through to column BV. This is a pain when trying to search for a certain company header as means lots of manual mouse scrolling. I know that if I use Excel built in ‘find’ function and specify a company name, Excel will locate and move the column right where I want it to be (which is column E4 as mentioned above) . However, using the built in ‘find’ function only works for exact matches.
    What I would like to do is create a combo box that acts as a dymanic search, so as I start typing in the box, it shows all of my column headers as a list and begins to filter down that list as I complete typing, until I have my exact match. Then (like the built in ‘find’ function) will display my column result.
    I know this is possible when using rows but I have no idea how to do this by columns, let alone merged ones.
    Could anybody help with this?
    Many thanks
    G1
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Combo Box to Filter by Merged Column Headers

    Check it out.

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    02-23-2007
    Location
    England
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2208 Build 16.0.15601.20072) 64-bit
    Posts
    102

    Re: Combo Box to Filter by Merged Column Headers

    Quote Originally Posted by davesexcel View Post
    Check it out.

    Please Login or Register  to view this content.
    davesexcel, that is exactly what I was looking for. Thank you so much. Can I ask how did you get to do it so quickly? I've been using excel on and off for years and I still cannot get passed the VBA basics, just can't seem to progress. You have saved me a lot of heart ache. Legend....and Happy New Year

+ 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] Cannot filter column due to merged cells
    By rayted in forum Excel General
    Replies: 5
    Last Post: 04-10-2018, 10:44 AM
  2. [SOLVED] How to Copy a filter data with headers, excluding the headers?
    By Elomaldo in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-16-2014, 03:35 PM
  3. Advanced Filter : One Criteria Cell Breaks the Filter - Returns Only Headers
    By PaulGW in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2014, 10:06 AM
  4. Creating a filter to select sets of column based on merged cell headers
    By keepingitcole in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-25-2013, 11:43 AM
  5. How do I use filter when a column contains combo boxes?
    By daymaker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-27-2011, 11:04 AM
  6. Combo box to draw column headers
    By shmee150 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2007, 10:07 AM
  7. Autofit Column Headers with wrapped text (Not a merged cell issue)
    By Mark in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-12-2005, 08: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