| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Conditional population of list boxes in Excel?
I have two list boxes that I want to populate in my worksheet which are
Marketing Group and Promotion Type. I want the Promotion Type values to be populated based on the value that is selected in the Marketing Group field. I can setup a lookup table on a hidden sheet, but I can't figure out how to link them up. Can anyone help me? I'm using Excel version 2002. |
|
#2
|
|||
|
|||
|
All the info at :
http://www.contextures.com/xlDataVal02.html "ccoursey" wrote in message ... I have two list boxes that I want to populate in my worksheet which are Marketing Group and Promotion Type. I want the Promotion Type values to be populated based on the value that is selected in the Marketing Group field. I can setup a lookup table on a hidden sheet, but I can't figure out how to link them up. Can anyone help me? I'm using Excel version 2002. |
|
#3
|
|||
|
|||
|
Thanks so much!
"ccoursey" wrote: I have two list boxes that I want to populate in my worksheet which are Marketing Group and Promotion Type. I want the Promotion Type values to be populated based on the value that is selected in the Marketing Group field. I can setup a lookup table on a hidden sheet, but I can't figure out how to link them up. Can anyone help me? I'm using Excel version 2002. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| eXceL 2003 - list or combo box question | Excel Discussion (Misc queries) | |||
| Create a cascading list box using Excel | Excel Discussion (Misc queries) | |||
| How to align check boxes on an Excel sheet? | Excel Worksheet Functions | |||
| How do I put a list of names and e-mail addresses in excel so tha. | Excel Discussion (Misc queries) | |||
| How do I import a Windows Explorer list into Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
