if cell contains text, then copy/paste on the next one

Hi,

I have multiples checkboxes on sheet 2.

On sheet 1, i want that the checkboxes (all in coloumn B) when checked copy the text in their respective row (in A) in sheet 1. This is easy....

What I want to do is that if in sheet 1. Check my file to see what i try to acheive!!!

So basicly, when there is text on Summary, and the checkbox is checked in the sheet input. I want that it copy to the next cell..


.test.xlsm