I am trying to set up check box that if checked then that row is copied to the next sheet.
To put in reference we have a cost catalog with a a ton of items. To prepare an estimate, the check box is checked on the item needed to copy to the next sheet for the specific project. There will be many with the check box empty that should not copy to the new sheet.
These functions do need the most recent version of Excel.
If you want more specific help, it would be far easier to give targeted suggestions if you were to post a copy of the spreadsheet you're working with (or a sample that mimics the reality). Not just an image, an Excel spreadsheet.