| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
My Excel drop-down list eliminates from list options chosen. Help
I set up a drop-down list for my spreadsheet with the options "Fax, Mail,
Pick-up, Interoffice". When I pick fax, the next block in that column only gives me the options, "Mail, Pick-up, Interoffice". If I pick one of those three, the next block has two options. I want to be able to reuse the options multiple times. I selected the range G3-G40, went under the Data menu, picked Validation, picked List from the Allow drop-down box, and entered "=(J2-J5)" in the Source text box. What am I doing wrong? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
My Excel drop-down list eliminates from list options chosen. Help
Sybil
Source should be of the form "=$j$2:$j$5" "Sybil" wrote: I set up a drop-down list for my spreadsheet with the options "Fax, Mail, Pick-up, Interoffice". When I pick fax, the next block in that column only gives me the options, "Mail, Pick-up, Interoffice". If I pick one of those three, the next block has two options. I want to be able to reuse the options multiple times. I selected the range G3-G40, went under the Data menu, picked Validation, picked List from the Allow drop-down box, and entered "=(J2-J5)" in the Source text box. What am I doing wrong? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
My Excel drop-down list eliminates from list options chosen. Help
"=(J2-J5)"
change to =($J$2:$J$5) HTH Regards, Howard "Sybil" wrote in message ... I set up a drop-down list for my spreadsheet with the options "Fax, Mail, Pick-up, Interoffice". When I pick fax, the next block in that column only gives me the options, "Mail, Pick-up, Interoffice". If I pick one of those three, the next block has two options. I want to be able to reuse the options multiple times. I selected the range G3-G40, went under the Data menu, picked Validation, picked List from the Allow drop-down box, and entered "=(J2-J5)" in the Source text box. What am I doing wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
| How can I select multiple options in an Excel 2003 drop down list | Excel Discussion (Misc queries) | |||
| I want to do a horizontal list - only 4 options chosen with mouse | Excel Discussion (Misc queries) | |||
| validation list with drop down list of options?? | Excel Worksheet Functions | |||
| How do I set up a drop down box in Excel with a list of options f. | Excel Discussion (Misc queries) | |||
Linear Mode
