Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Are drop-down menus that allow 1 entry per cell possible?
Oh mighty Oracle:
I have an document that a slew of users make local copies of and input data, which is then uploaded to an intranet app. The syntax on the data has to be perfect or it won't upload, and the data's syntax is apparently complex & hard to get right. So, I made drop-down selection menus, including cross-referenced ones so that, for example, when they pick a topic they can only choose from the correct sub-topics. But, for sub-topics, and a couple of other columns, they can enter more than one value, which have to be separated by ; with no spaces. I can't figure out a way to make it possible to use the drop-down menu to enter more than one selection for the same cell. Of course, I could make every possible combo of choices, but with over 50 sub-topics, you can see that would be quite a task. Thank you, dear Oracle, for your wisdom! Ross |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Are drop-down menus that allow 1 entry per cell possible?
http://www.geocities.com/excelmarksway
"creativeops" wrote: Oh mighty Oracle: I have an document that a slew of users make local copies of and input data, which is then uploaded to an intranet app. The syntax on the data has to be perfect or it won't upload, and the data's syntax is apparently complex & hard to get right. So, I made drop-down selection menus, including cross-referenced ones so that, for example, when they pick a topic they can only choose from the correct sub-topics. But, for sub-topics, and a couple of other columns, they can enter more than one value, which have to be separated by ; with no spaces. I can't figure out a way to make it possible to use the drop-down menu to enter more than one selection for the same cell. Of course, I could make every possible combo of choices, but with over 50 sub-topics, you can see that would be quite a task. Thank you, dear Oracle, for your wisdom! Ross |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Are drop-down menus that allow 1 entry per cell possible?
Hm...I guess I don't really get it, do you talk about drop-down menus in
there somewhere?? "exceluserforeman" wrote: http://www.geocities.com/excelmarksway "creativeops" wrote: Oh mighty Oracle: I have an document that a slew of users make local copies of and input data, which is then uploaded to an intranet app. The syntax on the data has to be perfect or it won't upload, and the data's syntax is apparently complex & hard to get right. So, I made drop-down selection menus, including cross-referenced ones so that, for example, when they pick a topic they can only choose from the correct sub-topics. But, for sub-topics, and a couple of other columns, they can enter more than one value, which have to be separated by ; with no spaces. I can't figure out a way to make it possible to use the drop-down menu to enter more than one selection for the same cell. Of course, I could make every possible combo of choices, but with over 50 sub-topics, you can see that would be quite a task. Thank you, dear Oracle, for your wisdom! Ross |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down List that has formatting of cell range Font ect. | Excel Discussion (Misc queries) | |||
data in cell not corresponding with entry | New Users to Excel | |||
Formula and Data Entry in a Single Cell | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) |