I'm a VBA novice, and have taken on a project that's currently beyond my skills, though I'm learning as fast as I can.

My user has a small database in Excel (700 rows, 30 columns). The order # field (Column D) is a 5-digit number (there are no alpha characters). There is also a single-digit line-item # (Column E). The DB is sorted, with the primary key being order # and the secondary key being line-item #.

The user wants a macro that will allow him to enter an order # and be taken to the first row in the database that matches that order #. He does not want to do this by using Excel's "Find" command -- he wants a macro.

For example, if the order # he wants to go to is 13002, he would be satisfied with either:
* Invoke the macro, then enter 13002 or
* Enter 13002 in a specific cell in the worksheet and then invoke the macro

In either case, the desired result is to activate the cell in Column D of the first row of the database where Order # = 13002.