filter from data in other worksheet

[npereira]

Hi again,

I have a problem that I cannot seem to resolve:

I have an invoice template:

Cell A1 is where I enter the part #

Cell B1 - B9 enters the relevant information of that found row (tha
works).

I would like to enter a few numbers of letters and have the cell filte
from the data on another worksheet. But I dont know how to acheiv
this.

Basicaly, have a drop down list of all cells in a specific row of a
External Worksheet. Si for example:

Part # 19956

You enter:
1
The list will bring up all cells that the data starts with 1

Then you enter :
19
The list narrows the filed down the the cells that the data starts wit
19

Then you enter:
199
The list narrows the filed down the the cells that the data starts wit
199

it basicaly narrows the field of choice that match what you enter.


Is this remotely possible? If so, How can I acheive this