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
But I Have to edit every checkboxs code.
Then i've figured out something like this:
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
Bookmarks