Check boxes

%3CLINGO-SUB%20id%3D%22lingo-sub-2733858%22%20slang%3D%22en-US%22%3ECheck%20boxes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2733858%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20set%20up%20check%20box%20that%20if%20checked%20then%20that%20row%20is%20copied%20to%20the%20next%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20put%20in%20reference%20we%20have%20a%20cost%20catalog%20with%20a%20a%20ton%20of%20items.%26nbsp%3B%20To%20prepare%20an%20estimate%2C%20the%20check%20box%20is%20checked%20on%20the%20item%20needed%20to%20copy%20to%20the%20next%20sheet%20for%20the%20specific%20project.%26nbsp%3B%20There%20will%20be%20many%20with%20the%20check%20box%20empty%20that%20should%20not%20copy%20to%20the%20new%20sheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2733858%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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.

1 Reply

@KWeed 

 

I'll refer you to the FILTER function.  Here's a video that explains it (among a few other new Dynamic Array functions). https://www.youtube.com/watch?v=9I9DtFOVPIg

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.

Learn everything about our brand-new Dynamic Arrays and how you can use them to build advanced spreadsheets. Arrays (CSE) have long been present in Excel, bu...