I am having some trouble trying to work out what is the best way to create a battleboard for our volunteer organization using excel. I have attached a sample of the board of what it looks like and to give you some idea of what l am trying to do.
Basically at the moment l have "shapes" in cells that are like a label and l want to be able to select a "shape"/label by one click of the mouse and then click the mouse in a cell on the right hand side of the worksheet which will place the selected "Shape"/Label neatly at a determined alignment in the cell.
Then l want to be able to mouse click that label again and be able to place it back in its neutral spot again with correct alignment or have a return button beside the label that would automatically return the "Shape"/Label back to its neutral spot.
Also would like to create a button that would return all "Shapes"/Labels back to their neutral position if possible.
Is this possible?
Can l use "Shapes/Objects" or should l use cells and if so how can l create a watermark or background behind each cell that has the title of the shape/label so it is returned to the correct spot?
Am l trying to create too much using excel and maybe should try creating it in basic from scratch?
I have basic programming skills and usually try and nut my way through things but have come to a big hurdle with this one so any help would be greatly appreciated.
The preview doesn't show the labels/shapes so l have taken a photo of the sheet in how it looks.
Basically at the moment l have "shapes" in cells that are like a label and l want to be able to select a "shape"/label by one click of the mouse and then click the mouse in a cell on the right hand side of the worksheet which will place the selected "Shape"/Label neatly at a determined alignment in the cell.
Then l want to be able to mouse click that label again and be able to place it back in its neutral spot again with correct alignment or have a return button beside the label that would automatically return the "Shape"/Label back to its neutral spot.
Also would like to create a button that would return all "Shapes"/Labels back to their neutral position if possible.
Is this possible?
Can l use "Shapes/Objects" or should l use cells and if so how can l create a watermark or background behind each cell that has the title of the shape/label so it is returned to the correct spot?
Am l trying to create too much using excel and maybe should try creating it in basic from scratch?
I have basic programming skills and usually try and nut my way through things but have come to a big hurdle with this one so any help would be greatly appreciated.
The preview doesn't show the labels/shapes so l have taken a photo of the sheet in how it looks.
Sample Battleboard.xlsm | |||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | |||
1 | Benalla Group | Mansfield Group | Wangaratta Group | Moyhu Group | District Vehicles | Fire 1 | Fire 2 | Fire 3 | Fire 4 | ||||||||||
2 | Name | Name | Name | Name | |||||||||||||||
3 | IMC | IMC | IMC | IMC | |||||||||||||||
4 | FGC | FGC | FGC | FGC | |||||||||||||||
5 | Baddaginnie T1 | Collar Tank | Barjarg T1 | Merton T2 | Boorhaman T1 | Colar Tank 1 | Bobinwarrah T1 | ||||||||||||
6 | Baddaginnie T2 | lima South T1 | Bonnie Doon T1 | Mt Buller PT | Bowmans T1 | Springhurst T1 | Collar Tank 3 | ||||||||||||
7 | Benalla T1 | Lurg T1 | Bonnie Doon T2 | Mt Buller S/on | Bowmans T2 | Springhurst T2 | Carboor T1 | ||||||||||||
8 | Benalla T2 | Lurg T2 | Booroolite T1 | Mt Buller Oversnow | Bowser T1 | Tarawingee T1 | Carboor ULT | ||||||||||||
9 | Benalla Pumper | Molyullah T1 | Collar Tank 4 | Mt Buller Support | Everton T1 | Wang Nth T1 | Cheshunt T1 | ||||||||||||
10 | Benalla ULT | Molyullah S/on | Glenroy/Merrijig | Tolmie T1 | Everton T2 | Wangaratta T1 | Edi T1 | ||||||||||||
11 | Benalla Big Fill | Samaria T1 | Merrijig FCV/slipon | Tolmie ULT | Eldorado T1 | Wangaratta T2 | Miliwa T1 | ||||||||||||
12 | Benalla FCV | Swanpool T1 | Goughs Bay T1 | Tolmie FCV | Eldorado ULT | Wangaratta Pumper | Miliwa T2 | ||||||||||||
13 | Benalla group FCV | Swanpool ULT | Goughs Bay Slipon | Woodspoint T1 | Glenrowan T1 | Wangaratta FCV | Moyhu T1 | ||||||||||||
14 | Boweya T1 | Tatong T1 | Jamieson T1 | Woodspoint ULT | Glenrowan ULT | Wangaratta TP | Moyhu FCV | ||||||||||||
15 | Chesney Vale T1 | Tatong ULT | Jamieson T2 | Woodspoint T2 | Greta T1 | Wangaratta MCV | Moyhu Slipon | ||||||||||||
16 | Delatite HVP | Taminick T1 | Jamieson FCV | Mansfield Group FCV | Greta T2 | Wang Gp FCV 1 | Myrrhee T1 | ||||||||||||
17 | Delatite HVP | Thoona T1 | Maindample T1 | Killawarra T1 | Wang Gp FCV 2 | Whitfield T1 | |||||||||||||
18 | Devenish T1 | Warrenbayne T1 | Maindample S/on | Killawarra ULT | Whitfield ULT | ||||||||||||||
19 | Goomalibee T1 | Whitegate T1 | Mansfield Pumper | Laceby West T1 | Whorouly T1 | ||||||||||||||
20 | Gooramabat T1 | Winton T1 | |||||||||||||||||
21 | Gooramabat T2 | HVP | |||||||||||||||||
22 | Gooramabat ULT | ||||||||||||||||||
Sheet1 |