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

Originally Posted by davesexcel

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