HELP: Sort of AutoComplete feature or i don't know
 

Hello,

i need a "little" help.

On Sheet2 i have few named columns.

Column B contains names from importers (IMPORTER_1; IMPORTER_2;...)

I also have named columns for each IMPORTER with his store locations
(IMPORTER_1 have a stores at locations A; B, C, ...etc. and it that columns
are named IMP_1_LOC; IMP_2_LOC; ...)

I want to (on Sheet1) pick from dropdown list in cell B5:

IMPORTER_1

after that i want to (in cell C5) to choose importer store location from
IMP_1_LOC ; but not from IMP_2_LOC.

So when i select B5=IMPORTER_1 THEN C5=something from IMP_1_LOC list.
If i choose B5=IMPORTER_2 THEN C5=something from IMP_2_LOC

It would affect the whole B column and also a C column with store locations.

Tnx in advance !!!

--


....
:: Dogg.Child:::Honored.member.of.The.Wu-Tang.Clan ::

dogg[AltGr+V]nkc-sisak.hr
....