Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic List Generation
I have an excel sheet that people fill out when they need a certain
request from me. So i created dropdown lists in the Excel sheet so the user doesnt need to type in each field, he can just select from the drop down. I have Two Fields: Type: Style: Now, the Type field is already a drop down list, the user can choose: A, B, C, or D. Now each Type has different styles. The Style field will also be a drop down list, BUT i want that list to depend on what the Type is. Say the user selects Type A. I want the Style drop down to Have 1,2,3,4,5,6,7. If Type B is selected I want the style drop down to have 8,9,10. Etc. How do I go about doing this? Im assuming a Macro of some sorts? Anyone have any good tutorials for this or examples? Thanks a lot! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic List Generation
http://pmexcelent.dk/Styles.xls
"wmureports" skrev: I have an excel sheet that people fill out when they need a certain request from me. So i created dropdown lists in the Excel sheet so the user doesnt need to type in each field, he can just select from the drop down. I have Two Fields: Type: Style: Now, the Type field is already a drop down list, the user can choose: A, B, C, or D. Now each Type has different styles. The Style field will also be a drop down list, BUT i want that list to depend on what the Type is. Say the user selects Type A. I want the Style drop down to Have 1,2,3,4,5,6,7. If Type B is selected I want the style drop down to have 8,9,10. Etc. How do I go about doing this? Im assuming a Macro of some sorts? Anyone have any good tutorials for this or examples? Thanks a lot! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic List Generation
awesome thanks
excelent wrote: http://pmexcelent.dk/Styles.xls "wmureports" skrev: I have an excel sheet that people fill out when they need a certain request from me. So i created dropdown lists in the Excel sheet so the user doesnt need to type in each field, he can just select from the drop down. I have Two Fields: Type: Style: Now, the Type field is already a drop down list, the user can choose: A, B, C, or D. Now each Type has different styles. The Style field will also be a drop down list, BUT i want that list to depend on what the Type is. Say the user selects Type A. I want the Style drop down to Have 1,2,3,4,5,6,7. If Type B is selected I want the style drop down to have 8,9,10. Etc. How do I go about doing this? Im assuming a Macro of some sorts? Anyone have any good tutorials for this or examples? Thanks a lot! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic List Generation
velcome
I had to name a,b,c,d as a. b. c. d. cus C is a reserved name thats why i put a dot in name "wmureports" skrev: awesome thanks excelent wrote: http://pmexcelent.dk/Styles.xls "wmureports" skrev: I have an excel sheet that people fill out when they need a certain request from me. So i created dropdown lists in the Excel sheet so the user doesnt need to type in each field, he can just select from the drop down. I have Two Fields: Type: Style: Now, the Type field is already a drop down list, the user can choose: A, B, C, or D. Now each Type has different styles. The Style field will also be a drop down list, BUT i want that list to depend on what the Type is. Say the user selects Type A. I want the Style drop down to Have 1,2,3,4,5,6,7. If Type B is selected I want the style drop down to have 8,9,10. Etc. How do I go about doing this? Im assuming a Macro of some sorts? Anyone have any good tutorials for this or examples? Thanks a lot! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Formula Generation | Excel Discussion (Misc queries) | |||
Dynamic chart generation: Run time Error '1004: Method 'Cells' of object'_Global' fai | Charts and Charting in Excel | |||
Random List Generation | Excel Worksheet Functions | |||
Automatic List Generation | Excel Worksheet Functions | |||
Dynamic Chart Generation | Charts and Charting in Excel |