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.