Use check boxes to create a new list

[apye]

Hello,

I'm wanting to use check boxes in an excel spreadsheet to automatically add the data from the line into a new sheet.

excel check box.PNG

As seen in the screen shot, I want to have the data for just those lines with a check mark to be copied and pasted into a new sheet.
Then I can print the of patient files to audit.

I'm not sure how I should set up the check boxes or what formulas to use.

[torachan]

Labour intensive setting up all those checkboxes
Use a small macro and 'x' in cell.
The macro reads the number of rows - no on sheet formula to expand or maintain.
Either run the macro 'TRANSFER' from the macro-reader or press the green button to place the filtered data on sheet 2.
torachan.

[ChemistB]

I agree with torachan: Checkboxes are a pain to work with.

I am supplying a formula solution (using torachan's workbook minus macros).
In Sheet2 A2 copied across and down

=IFERROR(INDEX(Sheet1!A$2:A$9, AGGREGATE(15, 6, (ROW(Sheet1!$A$2:$A$9)-ROW($A$2)+1)/(Sheet1!$F$2:$F$9="x"), ROWS($A$2:$A2))),"")