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.