OxmoPuccino
New Member
- Joined
- Feb 9, 2017
- Messages
- 9
Hi,
I created a file, Discography.xlsx, "Sheet 1": column A contains the names of Music Albums and column B contains the names of the tracks of the album in column A.
I selected all the tracks within an album from column B and Defined Name, the name of the album.
Sheet 2: All the albums are in column A and I selected them and Defined Name: Albums.
I created a second file, BestOf.xlsx, I opened the "Define Name" window:
Name: Albums
Refers to: =Discography.xlsx!Albums
(I did the same procedure to create names for each albums)
I created a drop down list in A2, Data Validation:
Allow: List
Source: Albums
So far it works since I can select the album name from a drop down list in my file BestOf.xlsx (as long as my file Discography.xlsx is open as well, an hindrance I can live with).
This is where I can't make it work.
File "BestOf.xlsx" cell B2, I want a drop down list that only gives me the choice of tracks from the album selected in A2.
What I did, Data Validation:
Allow: List
Source: Indirect(A2)
This doesn't work and I don't understand why since it works if the name range doesn't come from another file.
[I know I can't have space in name ranges so I've used underscore everywhere]
Thank you for your help!
I created a file, Discography.xlsx, "Sheet 1": column A contains the names of Music Albums and column B contains the names of the tracks of the album in column A.
I selected all the tracks within an album from column B and Defined Name, the name of the album.
Sheet 2: All the albums are in column A and I selected them and Defined Name: Albums.
I created a second file, BestOf.xlsx, I opened the "Define Name" window:
Name: Albums
Refers to: =Discography.xlsx!Albums
(I did the same procedure to create names for each albums)
I created a drop down list in A2, Data Validation:
Allow: List
Source: Albums
So far it works since I can select the album name from a drop down list in my file BestOf.xlsx (as long as my file Discography.xlsx is open as well, an hindrance I can live with).
This is where I can't make it work.
File "BestOf.xlsx" cell B2, I want a drop down list that only gives me the choice of tracks from the album selected in A2.
What I did, Data Validation:
Allow: List
Source: Indirect(A2)
This doesn't work and I don't understand why since it works if the name range doesn't come from another file.
[I know I can't have space in name ranges so I've used underscore everywhere]
Thank you for your help!