Creating Data series from a 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. |
All times are GMT +1. The time now is 02:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com