+ Reply to Thread
Results 1 to 3 of 3

Multiple drop-down lists to select different values from a table

  1. #1
    Registered User
    Join Date
    04-09-2007
    Posts
    25

    Question Multiple drop-down lists to select different values from a table

    HI Guys,

    got a little problem here. (For those of you, who by any chance are familiar with some tabletop Combat Miniatures Game with Units, that have some Equipment and Weapons, all the better ).

    I am creating a Sheet to function as a Roster for an Army. The User should be able to select Units in Column A with a Drop-down List for Name (from a Table, created on a different Sheet together with their Point Price, which is populated next to the Unit Type). Then in additional Columns he is to be able to select Equipment and Weapons, specific for the chosen Unit. Means, if he selects a Tank, he could only select a Cannon, a Missile Pod or a Mortar for the Weapon and Smoke launchers, Stealth Shield, Speed Boost or Hardened Armor for the Equipment.

    I have the basics covered and am able to populate Weapons and Equipment via Drop-down lists and also I am able to auto-populate them based on the Unit Type selection (with IF function etc.) from the respective part of the huge Weapons-Equipment Table.

    But I dont know how to somehow "cross-link" the Listboxes for Weapons (and also for Equipment, separately) so that if the User selects the Cannon in the first Weapon Drop-down List, he cant select it again in the second Weapon Drop-down list, just the Missile Pod or the Mortar. The same for Equipment so that he cant select more copies of the same thing.


    As for the Weapons-Equipment Table itself: it has around 25 different Units, each has its own available Weapons (ranging from 3 to 10) and available Equipment (roughly 20 different pieces each). So the total Row-count of the table is around 350. The Ranges are of course named for easier Validation reference.

    I saw here that such a Task could be done with auto-writing a second similar table next to the existing one and listing the chosen Weapons and/or Equipment in there so that you can check if they had been already chosen (see http://www.contextures.com/xlDataVal03.html ). But I guess this would not work in my case, because I am not selecting a Unit only once, but multiple times - e.g. 5 Copies of a Tank - and they may be customised differently (as for Weapons and Equipment).

    Can someone shed some light as to how to accomplish such a thing? (And sorry for such a looong text, I hope you are not lost now )

    Joe
    Last edited by joeyeti; 04-09-2007 at 05:27 PM.

  2. #2
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    I think these two links can provide you with pretty much everything you need to accomplish the task:

    http://www.contextures.com/xlDataVal02.html

    http://www.contextures.com/xlDataVal03.html

    Let me know if you need anymore help.

    EDIT: just noticed you have already visited the site i listed. Oversight on my part.

  3. #3
    Registered User
    Join Date
    04-09-2007
    Posts
    25
    Hi BigBas,
    sorry, my fault , edited the Post with the Link after you read I guess...

    And as said, I read these and also tried the ZIPped Example from http://www.contextures.com/xlDataVal03.html , but it is only working when you select Types in one Table (and subsequently selecting the second Column based on what is not yet selected elswhere). If you copy the whole table, you are still able only to select unused Sub-items, not make the whole selection independent...

    Joe

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1