Hi,
Data validation has to be within the same workbook, you can have a sheet
exclusive for your lists
Hope this helped

"apache007" wrote:

Dear All,

I have 2 workbooks = BookA and BookB

In BookA, I have these tables

CODE FRUIT

APP APPLE
ORG ORANGE
BNN BANANA
STAR STARFRUIT

How do I create in Book B, the following:

1. Cell with dropdown selection that contains TABLE FRUIT and make sure that
the user MUST stick with those choices

2. Let say, the user choose ORANGE, I need the result to display it's CODE.
Thus the result will be ORG.

I need to use those CODE to do searches or reference for other data in other
sheet/workbook.

Thanks for the tips.