PDA

View Full Version : [SOLVED] Data Validation



framcc06
05-08-2019, 01:42 PM
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).

24191 24192

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
05-08-2019, 06:43 PM
Hi Fra!
A simple example.


--Okami

framcc06
05-08-2019, 11:31 PM
Many thanks Okami, this is great.

Fra

大灰狼1976
05-09-2019, 01:53 AM
@Fra
You're welcome:)