By way of macro attached to a check box, what I want to do is be able to tick a box and then a concatenation of the resources and the mode (Day) appear in the list starting in A34.</SPAN>
Likewise, if a box is un-ticked, I would like the resource & mode taken away from the list
On the attached spread sheet, I have given examples.
I have a total at the bottom of the list that I would like to cater for any insertions. Potentially (very unlikely), this list could end up being 98 lines and I would like the list to be able to grow/shrink accordingly.
I will appreciate any help given!