software

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 amp;
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

www.geocities.com/excelmarksway

quot;creativeopsquot; wrote:

gt; Oh mighty Oracle:
gt; I have an document that a slew of users make local copies of and input data,
gt; which is then uploaded to an intranet app. The syntax on the data has to be
gt; perfect or it won't upload, and the data's syntax is apparently complex amp;
gt; hard to get right.
gt;
gt; So, I made drop-down selection menus, including cross-referenced ones so
gt; that, for example, when they pick a topic they can only choose from the
gt; correct sub-topics. But, for sub-topics, and a couple of other columns, they
gt; can enter more than one value, which have to be separated by ; with no
gt; spaces. I can't figure out a way to make it possible to use the drop-down
gt; menu to enter more than one selection for the same cell. Of course, I could
gt; make every possible combo of choices, but with over 50 sub-topics, you can
gt; see that would be quite a task.
gt;
gt; Thank you, dear Oracle, for your wisdom!
gt; Ross

Hm...I guess I don't really get it, do you talk about drop-down menus in
there somewhere??

quot;exceluserforemanquot; wrote:

gt; www.geocities.com/excelmarksway
gt;
gt; quot;creativeopsquot; wrote:
gt;
gt; gt; Oh mighty Oracle:
gt; gt; I have an document that a slew of users make local copies of and input data,
gt; gt; which is then uploaded to an intranet app. The syntax on the data has to be
gt; gt; perfect or it won't upload, and the data's syntax is apparently complex amp;
gt; gt; hard to get right.
gt; gt;
gt; gt; So, I made drop-down selection menus, including cross-referenced ones so
gt; gt; that, for example, when they pick a topic they can only choose from the
gt; gt; correct sub-topics. But, for sub-topics, and a couple of other columns, they
gt; gt; can enter more than one value, which have to be separated by ; with no
gt; gt; spaces. I can't figure out a way to make it possible to use the drop-down
gt; gt; menu to enter more than one selection for the same cell. Of course, I could
gt; gt; make every possible combo of choices, but with over 50 sub-topics, you can
gt; gt; see that would be quite a task.
gt; gt;
gt; gt; Thank you, dear Oracle, for your wisdom!
gt; gt; Ross