| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating Data series from a table from diff. Workbook | Excel Discussion (Misc queries) | |||
| Creating Data series from a table from diff. Workbook | Excel Discussion (Misc queries) | |||
| Excel 2002; copy formulas to one workbook to another diff data | Excel Worksheet Functions | |||
| data transfer from Excel to Access but the new table stru is diff | Excel Discussion (Misc queries) | |||
| Creating a cell so data goes into a table | Excel Discussion (Misc queries) | |||
Linear Mode
