Tick box with code

[Matt_Chelmsford]

Afternoon all,

I have a column full of resourses - L8 to L25
I have a row full of modes - N8 to T8

At any time, it is possible that I could be using any of the resources under any mode. I would like to put a check box for every combination of modes and resources.

Once I have a ticked a box I would like to generate something that will put a concatenation of the Resource and Mode in Cell A34, the next time I tick a box I would like the concatenation to be put in Cell A35 but also copying the format of the line 34.......and then so on.

If I untick a box I would like the refering line to be deleted but not Line 34 as this is the master formated line.

Regards

Matthew