Hide rows as you type

Hi, I have some programming experience but I'm still pretty new to excel programming. My problem is that I have a sheet of 2500+ items in rows, each item has an ID, Name, Price, Quantity, etc. I have to update the quantity on some items on a daily basis and don't want to have to scroll down, nor do I want to use the find window. I want to have a textbox on top of my rows which, after I type a letter, hides all rows in which the name doesn't start with that letter. For example if I type the letter 's', only items with the letter 's' are displayed while the rest are hidden. If I continue typing, for example 'su' it will further hide the rows where the item doesn't start with 'su', and so on. Also, I want the same text box to have the same effect on ID's. In other words, if I start typing either its name or its ID, it will narrow down the list according to each. How can I do this?????

Screenshots of what I want are attached...

Hi and welcome to the board.
Why not use the Autofilter ?

Thanks! And yeah autofilter is fine, but I'm actually making this for someone who has very little excel and computer experience in general and want to simplify it for him as much as I can. Well if a function like that doesn't exist I guess I'll have to settle for autofilter.

WoW!!! Exactly what I was looking for! U da man!
Is it possible to expand this to include the first row as well?? In other words, if I type in the ID OR name, it will narrow down the list...

Thanks again!

Great! That's just what I need! Thanks a bunch Perhaps your solution can be useful to other people as well... Cheers!

Another question on the same subject, how can I modify the code to start from the third row instead of the second, or to only work on a table that I specified?

Perfect.

Now I have another related problem, I want to protect the workbook from editing but the autofilter doesn't want to work on a protected sheet. Is there a way around this?

I'm gonna say this one more time...
U DA MAN!

Hello snb,

Would you mind helping me with this problem: I want to extend the number of fields to be auto-filtered, more than just 2. However, I couldn't do that as Excel either hide everything after I typed in the textbox, or show "application defined or object defined error".