Hi everyone,

I have little problem with copying data with checkbox. e.g. i have checkbox in cell B2 and n checkboxes in lower rows column B. I want when checkbox is checked the data (same row where checkbox is) in range (C2:E2) is copied to sheet "Matrix", with input box which asks for number of pieces to order and put it in column G (same row in "Matrix" sheet).

In "Matrix" i have tabel where D6 is first available cell to paste data from source sheet. Range is limited with (D6:G18) so 13 rows are availabel

This is what I've got so far
Please Login or Register  to view this content.
But I Have to edit every checkboxs code.

Then i've figured out something like this:
Please Login or Register  to view this content.
But it doesn't copy data to next row below D5 in "Matrix" sheet, only to second row from top of sheet

I hope it's clear enough

regards