| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Creating Data series from a table from diff. Workbook
Please refer
http://www.contextures.com/xlDataVal11.html -- If this post helps click Yes --------------- Jacob Skaria "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 a data series using another worksheet? | Excel Discussion (Misc queries) | |||
| Excel 2002; copy formulas to one workbook to another diff data | Excel Worksheet Functions | |||
| chart data series -- plot a table as a single series | Charts and Charting in Excel | |||
| data transfer from Excel to Access but the new table stru is diff | Excel Discussion (Misc queries) | |||
| Creating a series of data | Excel Worksheet Functions | |||
Linear Mode
