Hi,
I have a 3 column list 'master.xls'.
In another WB I have a "report" worksheet that I want to reference the master wb.
So, a user will want to select from a list an option found in the master.
Then, dependant on what is slected from the first list will be given a choice from a second list.
EG:
MASTER:
Country City Code
Australia Sydney S123
Australia Brisbane B123
Australia Melbourne M123
America Las Vegas L123
America New York NY12
America LA LA12
England London LO12
Italy Rome R123
(The master.xls will be over 700 rows.)
REPORT:
Combo1 - user selects America
Combo2 - user can only select Las Vegas, NY or LA, but see's both the City and Code Columns in the drop down list.
The options selected will need to then be linked to a cell, inputing the selection the user has made. (not a number based on it's position in the list)
Any thoughts, Idea's or help will be greatly appreciated.
I have been able to create dynamic ranges for the master, and although data validation would be my first preference, that can't be done with an external range.
I thought about getting the external range copied into the report workbook each time, but had trouble with that, and honestly think there would be a better way.
(there is also a likely hood the "report" worksheet's file name will be changed after each use)
Cheers,
Nick
I have a 3 column list 'master.xls'.
In another WB I have a "report" worksheet that I want to reference the master wb.
So, a user will want to select from a list an option found in the master.
Then, dependant on what is slected from the first list will be given a choice from a second list.
EG:
MASTER:
Country City Code
Australia Sydney S123
Australia Brisbane B123
Australia Melbourne M123
America Las Vegas L123
America New York NY12
America LA LA12
England London LO12
Italy Rome R123
(The master.xls will be over 700 rows.)
REPORT:
Combo1 - user selects America
Combo2 - user can only select Las Vegas, NY or LA, but see's both the City and Code Columns in the drop down list.
The options selected will need to then be linked to a cell, inputing the selection the user has made. (not a number based on it's position in the list)
Any thoughts, Idea's or help will be greatly appreciated.
I have been able to create dynamic ranges for the master, and although data validation would be my first preference, that can't be done with an external range.
I thought about getting the external range copied into the report workbook each time, but had trouble with that, and honestly think there would be a better way.
(there is also a likely hood the "report" worksheet's file name will be changed after each use)
Cheers,
Nick
