Searching and autofiltering the result on the same worksheet.

[aloy78]

Hi there,

I would like to have a search function (cell b4) in my worksheet. To start the search I will key in B4, then press enter. The search reference will be based on two columns (i.e. artist and song title) and it will autofilter the results in the same worksheet.

I've attached a sample for an idea :yes

[Bob Phillips]

What is wrong with just autofilter? What does this new addition provide?

[aloy78]

well, there's nothing wrong actually :). It's just that I would love to have a "search" for specific words. I'll roughly explain why i would need a search.
Say if I were to look for a song and I dun remember the full name of it. With the conventional auto-filter; I would have to click on the auto filter tool, then click "text filters", choose my filter selection, type in my text. You know, it's just the hassle that I dun like.
With a search, I just have to type and enter, results shown. It's more faster that way especially when my play lists grows larger and larger and the song names become more unique. Hope it's not too much to asked for :3