Hi Peeps,

I am looking to create a search macro that will search a column of data (numbers starting at cell A5) for the number typed into cell A3. As a user types the word, the sheet will move closer to the matching word. The column is sorted from lowest to highest numbers.

Simple Example:

A user wants to find number 024 (corresponds to an item key). They type in 0 and the document jumps to the first "0" it finds in that column (perhaps even highlighting the corresponding row temporarily). They then type in a "2" and the document jumps to the first number beginning with "02". They finally type the 4 and it jumps "024". If the number cannot be found, a msg window informs the user and cell A3 is cleared.

As you can see, it narrows down the search as the user types more numbers; particularly usefull when dealing with 1000's of catagorised items codes.

I am not where sure where to start with this one, I am assuming there is a way to run a macro upon a cell contents changing.

If anyone can point me in the right direction, it would be greatly appreciated.

Many Thanks,

Martin