I have a numbers file with 2 sheets: sheet1 and sheet2.

On sheet1 is where I am entering some data in some cells. On sheet2 there is a transactions table with different entries.

Is it possible to have a button or something in sheet1, where I can enter some information in some cells sheet1, and when I press that button, it adds a new entry in the transactions table in sheet2 with some values from sheet1?

Its straight forward to use values from one sheet into another by using a format like SHEETNAME::TABLENAME::CELL in a formula, but I don't know how I can (or if I can) achieve the above.

| improve this question | | | | |

Seems like iOS has this feature under the names of Forms, just like you add a sheet, you can add a Form for a table. Don't have it on the Mac App, but that seems to be it.

| improve this answer | | | | |

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .