Automatically remove entries from one sheet when added to another in Numbers

It cannot "remove" it from the need sheet/table but you can make it so the row it is on becomes hidden.

Formula in cell C2 of the Need table =ISERROR(XMATCH(B,Have Table::B,0))

If version 14.4 or later it will spill down to the rest of the column. If an earlier version you'll need to fill down to complete the column.

Set up the filter as shown on the right for column C of the Need table. Turn it on (it is currently off in my example of superhero figures). Rows where column C is TRUE will show. Rows that are FALSE will be hidden.

To add more data to the Need table you have to first turn off the filter.

Looking at my example, I should have labeled column C "Don't Have", not "Have". No change in the formula is required and the end result is correct, but TRUE/FALSE were backward from what the header said. Also, you can hide column C if you don't want to see it at all.

Here is an alternate idea if you have version 14.4 (or more recent):

Column C is a column of checkboxes. The filter on the Need table is as shown (currently is turned off).

Formula in B2 of Have Table is =FILTER(Need Table::B,Need Table::C=TRUE,"")

It will spill into the rows below

With the filter on, only the unchecked rows will be shown in the Need table. You can add new rows to the table without turning the filter off. Checked rows will automatically populate the Have table and become hidden in the Need table. If you make a mistake, you'll have to turn off the filter to uncheck a box.

bromwyn wrote:

This is very helpful thank you but is there a way that if i tick the box it’ll move it or add it to another sheet and not a table within the same sheet?

Have you considered setting up the table on the same sheet? That's easier. Then when it's working as you want, you can move the table to another sheet. Click it, then click the concentric circles on its upper left corner, command-c to copy, navigate to the destination sheet, and command-v to paste.

SG

bromwyn wrote:

This is very helpful thank you but is there a way that if i tick the box it’ll move it or add it to another sheet and not a table within the same sheet?

The tables can be in tables on different sheets. It was meant as an example to show how what you requested can be done, not as the final product.