Copy/paste text from a cell on sheet 1, to sheet 2 only if tickbox is checked

[REllaLil]

Hello

I'm a real novice on excel (I thought I was quite good until I read up trying to solve this problem).

I have a questionnaire on sheet 1, each question has a tick box. I want to copy the question and paste it onto page 2, but it will be to different cells if checked / unchecked.

Any help would be much appreciated!

Thank you.

[rollis13]

Have a try with this macro to be pasted in a module; I'm assuming that your questions are in column A.

Please Login or Register  to view this content.