Creating data cell from other table from diff. Workbook
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. |
Creating data cell from other table from diff. Workbook
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. |
All times are GMT +1. The time now is 08:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com