Data Validation

[framcc06]

Hi Folks,

I have a fair idea of how data validation works, but I am struggling to come up with a solution to the following.

I have two sheets in my sample workbook, one is where my data is stored and the other is where I would like the user to complete (see below images).

Test1.PNG Test2.jpg

What I would like to implement is when user types in the Customer number on the entry form, the cell to the right will populate a drop-down cell with available options. As in the case above there is two instances of the same Customer number on the data sheet, so this should provide two options for the order reference number on the entry form.

Appreciate any help.

Thanks

Fra

[大灰狼1976]

Hi Fra!
A simple example.


--Okami

[framcc06]

Many thanks Okami, this is great.

Fra

[大灰狼1976]

@Fra
You're welcome