Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2002 dropdown lists
I've created a dropdown list showing each of our customers. Each customer has
several locations, so in another dropdown list I would like to show those locations based on what customer was chosen in the first dropdown list. For example, Customer 1 is chosen, I would like the Location dropdown list to show only locations for customer 1. Is this possible? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2002 dropdown lists
try it
http://www.contextures.com/xlDataVal10.html hth regards from Brazil Marcelo "projectmgr" escreveu: I've created a dropdown list showing each of our customers. Each customer has several locations, so in another dropdown list I would like to show those locations based on what customer was chosen in the first dropdown list. For example, Customer 1 is chosen, I would like the Location dropdown list to show only locations for customer 1. Is this possible? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2002 dropdown lists
This page might be better <g:
http://www.contextures.com/xlDataVal02.html Marcelo wrote: try it http://www.contextures.com/xlDataVal10.html hth regards from Brazil Marcelo "projectmgr" escreveu: I've created a dropdown list showing each of our customers. Each customer has several locations, so in another dropdown list I would like to show those locations based on what customer was chosen in the first dropdown list. For example, Customer 1 is chosen, I would like the Location dropdown list to show only locations for customer 1. Is this possible? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Add-in: Open Database Connectivity available for Excel | Excel Discussion (Misc queries) | |||
IF/THAN with regards to 2 Dropdown Lists in Excel? | Excel Worksheet Functions | |||
Cells User Select Locked after upgrade to Excel 2002 | Excel Discussion (Misc queries) | |||
Formula Arrays VERY SLOW in Excel 2002 | Excel Worksheet Functions | |||
Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) |