Getting an error 'evalutates to an error' when I try to create the Drop Down LIst. Here is what I have done.
1. Created a Workbook, 'wells-and-doi.xlsx'
2. Created a Dynamic Range, 'WellNames,' in Column B. Confirmed that it exists by pressing F5 and entering the name and yes, it highlighted the range.
3. Created another Workbook, call it Workbook2. In a certain column, I will want to enter a well name by selecting it from a Drop Down list, which will be populated by the names of the wells from the Dynamic Range in the other workbook, mentioned above.
In this Workbook2, I created a named range by doing this...
On the Ribbon, clicked the Formulas tab, then clicked Define Name.
Typed a name for the List, 'WellNamesList'
From the Scope drop down, selected Workbook
In the refers to box, typed:
=wells-and-doi.xlsx!WellNames
Clicked OK
Got it from here...
http://blog.contextures.com/archives...#ixzz1R0UIIkj8
4. Both workbooks are open. In Workbook2, I did this, something else I found online...
Create the Dropdown List
- Select the cells in which data validation will be set.
- On the Ribbon, click the Data tab, then click Data Validation
- In the Allow box, choose List
- In the Source box, type an equal sign, then the list name, e.g.: =MyCustList
- Click OK
So, in that box, I typed '=WellNamesList.'
===
When I do the last step above, it says evalutates to an error." I can't find the error.
So, to recap, I have the first workbook (wells-and-doi.xlsx) and it contains the Dynamic Named Range 'WellNames.' I have the second work, Workbook2, which has the named range 'WellNamesList.' This named range is pointed to wells-and-doi.xlsx!WellNames. I then created a drop down list, to be populated by the named range 'WellNamesList.' (I typed '=WellNamesList' in the Source box.)
I followed these instructions...
http://blog.contextures.com/archive...n-list-from-different-workbook/#axzz1Qzi6zJ5j
1. Created a Workbook, 'wells-and-doi.xlsx'
2. Created a Dynamic Range, 'WellNames,' in Column B. Confirmed that it exists by pressing F5 and entering the name and yes, it highlighted the range.
3. Created another Workbook, call it Workbook2. In a certain column, I will want to enter a well name by selecting it from a Drop Down list, which will be populated by the names of the wells from the Dynamic Range in the other workbook, mentioned above.
In this Workbook2, I created a named range by doing this...
On the Ribbon, clicked the Formulas tab, then clicked Define Name.
Typed a name for the List, 'WellNamesList'
From the Scope drop down, selected Workbook
In the refers to box, typed:
=wells-and-doi.xlsx!WellNames
Clicked OK
Got it from here...
http://blog.contextures.com/archives...#ixzz1R0UIIkj8
4. Both workbooks are open. In Workbook2, I did this, something else I found online...
Create the Dropdown List
- Select the cells in which data validation will be set.
- On the Ribbon, click the Data tab, then click Data Validation
- In the Allow box, choose List
- In the Source box, type an equal sign, then the list name, e.g.: =MyCustList
- Click OK
So, in that box, I typed '=WellNamesList.'
===
When I do the last step above, it says evalutates to an error." I can't find the error.
So, to recap, I have the first workbook (wells-and-doi.xlsx) and it contains the Dynamic Named Range 'WellNames.' I have the second work, Workbook2, which has the named range 'WellNamesList.' This named range is pointed to wells-and-doi.xlsx!WellNames. I then created a drop down list, to be populated by the named range 'WellNamesList.' (I typed '=WellNamesList' in the Source box.)
I followed these instructions...
http://blog.contextures.com/archive...n-list-from-different-workbook/#axzz1Qzi6zJ5j
