I would like to write a macro that looks at the checkbox in the adjacent sell and if it is checked then put the data into a new list. I would like to do this in a macro as the data is in the thousands.

maybe the code should do this

if b2="true" then put B1 in the next avaiable spot below F1
repeat for all of Col B.

inputs results
test FALSE gh
hdh FALSE djh
gh TRUE ty
djh TRUE djh
yt FALSE fj
ty TRUE djh
djh TRUE fjh
fj TRUE gggjt
djh TRUE
fjh TRUE
djh FALSE
rthjd FALSE
rtjh FALSE
tt FALSE
yt FALSE
gggjt TRUE



sample attached

Test checkbox.xlsm

thanks in advance