Is there any way that I can set Excel to live search as I type a search? Similarily to how Google or the Windows Start Menu do it where you can type ans as you type your search is refined?
I am doing hundreds of searches over a Chemical Database file for one of my summer jobs and having to hit enter and then refine from there is exhaustively cumbersome.
Any help is greatly appreciated!
-VincibleAndy