Ok so I'm creating a Template Purchase order and an info sheet - or at least I'm trying... I'd like to no how to run macros on tick boxes which would copy cells on the relevant row to each tick box and then paste them sequencialy row by row on the template sheet . I no its do'able I just lack the knowledge and understaning of formatting the code.... but I'm happy to try and learn from a few examples Thanks in advance.