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
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