In numbers mac if i check an item(in checkbox) I want that item to be automatically shifted to another table.

Hi Monish,

You won't be able to do this within Numbers. It is possible Applescript could do this.

I would suggest another approach to you data that does not require the deletion. It would be a simple matter to have a data table that sends the data in a row to one of 2 different tables depending on a checkbox.

quinn

Don't forget also that you can use the power of filters:

Giving this:

Often much easier than moving rows to another table, etc.

SG

Hi Monish,

I have approached this as a 'shopping list' or similar.

No need to delete or move rows from Table 1.

No need to filter Table 1. Leave that intact so you can tick and untick checkboxes.

Insert another table to list those items that you have ticked.

In the 'Shopping List' table, formula in A2 (and Fill Down and Fill Right)

=IF(Table 1::$A2,Table 1::B2,"")

That will list every item and price where there is a tick in column A.

Now Filter the 'Shopping List' table to show only those rows where the Price is greater than zero

That filter will work when you choose different items in Table 1

By the way, the formula in the Footer Row of 'Shopping List' is

=SUM(B)

I like Header Rows, Header Columns and Footer Rows in Numbers. They allow a formula to refer to all Body Cells. Very powerful!

Regards,

Ian.

"I unfortunately can't use filters because i also want to see the checked items ..... So i need it to be in another table."

Do you need to see the checked AND unchecked items at the same time? Will you be able to do so if they are on separate tables, as you request?

The filter suggested by SG will let you quickly switch between seeing the Checked rows, the Unchecked rows, or All rows by choosing TRUE or FALSE in the Filter Table submenu or by deselecting the Filter Tables menu item (to show all rows).

Unless you have very small tables , I suspect that switching filters will be faster than moving your view from one table to another.

Regards,

Barry