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
Bookmarks