Autofiltering text as you type

**seabass** · 01-06-2010, 05:23 PM

Here is the challenge.....

I have a spreadsheet with approx 12000 rows... 8 columns... it represent material in our inventory and each row is a specific records that contains a lot of info....

I need to be able to have a field in a top pane (could be top row i guess... or a small form) where i can start typing text and as i am typing, the spreadsheet auto filter the rows to display only whatever fit my parameters i am typing....

a few example of what i will type in are:

bearing*2217
valve*gate*3*150
asco*8344

as you may have guess, "*" is a wildcard....

The spreadhseet are generated using crystal reports over night, so i am not sure how i can or should use macros or add in for this....

thanks

Sebastien

**davesexcel** · 01-06-2010, 08:01 PM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

**seabass** · 01-07-2010, 01:51 PM

good idea... here is a sample of the data i want to filter....

hope this make sense.....

**davesexcel** · 01-07-2010, 09:13 PM

Give this a try, more successful then I thought it would be, as this was the first time I had seen this question. Type the text in the TextBox in column B, macros need to be enabled for this to work.

Please Login or Register  to view this content.

Here is your example back.

**seabass** · 01-09-2010, 10:13 AM

That is great !!!!!! Thanks a lot....
Should i start a new thread on this or keep going for tune in stuff.....????

The next question on this is how can i have the same macros available on multiple spreadhseet.....????

For example, every night, an updated excel datasheet will be generated from the database where the original data reside, is there a way to have this macro added automatically to the new spreadhseet ????

FYI, some new item could be added, QOH will change daily on some items....

Thanks in advance...

**DIMSKAL** · 08-09-2011, 06:14 AM

This looks very useful indeed, I would like to use this for my sheet but as a beginner with code I would like this to search in col A...also, would I add the macro code as a module and if so how would it run? really sorry for the noob questions, but as I said this would be perfect for me to use

**davesexcel** · 08-09-2011, 09:13 PM

Attach a simple sample workbook to set this up for you.

**maz67** · 06-07-2012, 12:22 PM

Is there any way to do this with a cell instead of a text box?

**arlu1201** · 06-07-2012, 01:15 PM

Maz67,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.