combo box reference external dynamic range

nish1585

New Member
Joined
Apr 30, 2010
Messages
2
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
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,259
Messages
5,769,082
Members
425,516
Latest member
Melzebu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top