up vote 0 down vote favorite
share [g+] share [fb]

I have products sheet in excel workbook but when i add new order line in order sheet in same workbook, i want to filter products when i press keys to write product name.

Is there any way to show filtered product names in order sheet?

For example: When I write "Chee", it should filter the column and show relevant cells under it: 

Chee
-----------
Cheese Dutch
Cheese French
Cheeseburger
Cheetos
link|improve this question
71% accept rate
2  
Looks like you're in need of a database! ;) – BloodPhilia Aug 19 '10 at 22:30
I'm not Catholic, but St. Isidore protect us from another "Excel Database" ... I strongly suggest adopting a philosophy of "the right tool for the job." – Adrien Aug 19 '10 at 23:35
Do you think this is difficult thing and can't be in excel ? Do you know excel row limit? it is always increasing, why? Why do people need to have more line than 64000? Why has it 1,048,576 row limit now? Do you still think it isn't like db? It is searching in other workbook(databases)'s sheet(Table). It is returning a vector or scalar value. And you can bind excel file as a db. Think again, it is trying to be db something like more functional classical db and more compact isn't it? – uzay95 Aug 20 '10 at 18:54
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

Browse other questions tagged or ask your own question.