You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

anubhav6 Author

Level 1

10 points

How to copy all rows of a table in which a checkbox is ticked in Numbers?

I have a total of three sheets, one is a Master sheet and the other 2 sheets have a table each of nearly identical data (I could move them all to the same sheet if that makes things any easier). The 2 tables on the other 2 sheets also have a column of checkboxes; I need the rows that are checked on either table to get automatically copied into the Master sheet's table (and of course, when they are unchecked, to be deleted from the Master sheet's table).

Does Numbers have any feature that can do this for me?

Posted on Mar 24, 2022 7:56 PM

Top-ranking reply

SGIII

Level 8

36,140 points

Posted on Mar 24, 2022 8:12 PM

anubhav6 wrote:

(I could move them all to the same sheet if that makes things any easier).

Yes, keeping like ("nearly identical") data together in the same table (not "sheet") is in almost all cases FAR easier and more efficient than maintaining it in different places in your document.

Then you can use filters and/or formulas to display or extract subsets of your data.

View in context

How to copy all rows of a table in which a checkbox is ticked in Numbers?

Similar questions