Ill try and describe what ive done as best as i can.
Basically this spreadsheet is for a tabletop battle game called Warhammer.
Every character/unit has a point value and you build a army up to a certain amount of points.
In my spread sheet ive made a block for each unit and character choice that my army has available. I can put in how many of each unit i want, and what equipment choices ect i want on them and it keeps track of how many points ive used.
The way i have it set up now is having one tab for each type of unit and every unit type shows on that sheet, even if i dont actually use that unit in my army. Also theres no way to have multiple regiments of the same unit type without copy/pasting a new block in.
What i would like to do (if possible), is to start with a basically empty spread sheet that has the categories: Lords, Heros, Core, Special, Rare.
Each category with a validation dropdown box with every unit type in that category listed, so when i select a unit it creates the corresponding block for that unit under its category. When i add another, i want it to just create another block under that category.
This will allow me to create multiple blocks of the same unit type and also to have my entire army listed neatly on one sheet instead of 5.
Im not completely computer illiterate and could probabl copy/paste in a VBA code and get it working if it is completely necessary.
Thanks in advance and feel free to ask me to clarify anything, as i know my question is probably confusing.
Basically this spreadsheet is for a tabletop battle game called Warhammer.
Every character/unit has a point value and you build a army up to a certain amount of points.
In my spread sheet ive made a block for each unit and character choice that my army has available. I can put in how many of each unit i want, and what equipment choices ect i want on them and it keeps track of how many points ive used.
The way i have it set up now is having one tab for each type of unit and every unit type shows on that sheet, even if i dont actually use that unit in my army. Also theres no way to have multiple regiments of the same unit type without copy/pasting a new block in.
What i would like to do (if possible), is to start with a basically empty spread sheet that has the categories: Lords, Heros, Core, Special, Rare.
Each category with a validation dropdown box with every unit type in that category listed, so when i select a unit it creates the corresponding block for that unit under its category. When i add another, i want it to just create another block under that category.
This will allow me to create multiple blocks of the same unit type and also to have my entire army listed neatly on one sheet instead of 5.
Im not completely computer illiterate and could probabl copy/paste in a VBA code and get it working if it is completely necessary.
Thanks in advance and feel free to ask me to clarify anything, as i know my question is probably confusing.
