Skip to main content
Ask Different

Return to Question

added 29 characters in body
Source Link
Ufder
Ufder
  • 111
  • 4

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

On sheet1 is where I haveam entering some columnsdata in which there are some cells. On sheet2 there is a transactions table with different entries.

Is it possible to have a buttonbutton or somethingsomething in sheet1, where I can enter some information in some cells sheet1, and when I press that button or somethingbutton, 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.

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

On sheet1 I have some columns in which there are some cells. On sheet2 there is a transactions table with different entries.

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

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.

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.

Source Link
Ufder
Ufder
  • 111
  • 4

Generate a new table entry in one sheet from another

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

On sheet1 I have some columns in which there are some cells. On sheet2 there is a transactions table with different entries.

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

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.