[ms office - 2010] Excel Help Required - Auto insert data

[TechSupp]

In excel I am trying to generate an assessment sheet where if I tick (using control check boxes which I have managed) certain statements in a list it will place them one under the other on a new sheet. I can get it to put the statements when checked on a new sheet but only where the code is, I want it to automatically create the list one after the other even if the statements selected are not selected one after the other i.e. when statements 1,4,6 and 7 are ticked they appear on another sheet under each other 1,2,3,4, is this possible?

[Seb1780]

A bit of VBA should do it, I'll have a look in the morning.

[Seb1780]

An early morning Google revealed this, which I think can be used in your situation.

 

Excel - copy certain rows from worksheet in another worksheet - Stack Overflow