Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 .... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Offer a feature to disable the sort warning in Excel 2003 | Excel Discussion (Misc queries) | |||
Sort feature | Excel Discussion (Misc queries) | |||
autocomplete | Excel Worksheet Functions | |||
New featu Two rows join & sort together. | Excel Discussion (Misc queries) | |||
Using autocomplete | Excel Worksheet Functions |