| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding a Workbook based on a Cell information in another Workbook
In Workbook 1 I can select from a dropdown list of several workbooks that I
have. Based on what is selected, I would like to come up with a formula that would put that info into a formula so that I can gather the information from the second workbook. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding a Workbook based on a Cell information in another Workbook
Hi,
The INDIRECT() function will not work in this case because of different workbooks. You can download and install the following addin http://www.download.com/Morefunc/300...-10423159.html and then use the INDIRECT.EXT function. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Walter" wrote in message ... In Workbook 1 I can select from a dropdown list of several workbooks that I have. Based on what is selected, I would like to come up with a formula that would put that info into a formula so that I can gather the information from the second workbook. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set up worksheet tabs to change based on a workbook cell | Excel Worksheet Functions | |||
| Pulling cell information from one workbook to another | Excel Worksheet Functions | |||
| Copy cells based on conditions in one workbook to another workbook | Excel Discussion (Misc queries) | |||
| Copy cells based on conditions in one workbook to another workbook | Excel Worksheet Functions | |||
| Moving Cell Information from one workbook into another workbook | Excel Worksheet Functions | |||
Hybrid Mode
