Generate a new table entry in one sheet from another

numbers

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.

Best Answer

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.

Related Solutions

Copy static cell value in Numbers

You need to use the $ char e.g. like this: =$D$3

Apple numbers Filling data into a table using AppleScript

For your second block of assignments, remove the second 'the value of' from each line so that they look like this:

set the value of cell "K2" to fileinfolder

That second 'value' is redundant.

As an aside, the error is peculiar in that it should probably be a 'script error' that can't get the value of '1.0', for example. So whichever cell is generating the error is probably indicating to the script that it's a boolean or something. But this isn't the source of your problem, just a symptom.

NB To test this, I simply used a column of numbers ranging from 1 to 17 to supply the first block of assignments.

Best Answer

Related Solutions

Copy static cell value in Numbers

Apple numbers Filling data into a table using AppleScript

Related Question