D
Dogg Child
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
....
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
....