Copy formula between sheets

Omit the reference to "Sheet1 :: ". Numbers looks for a tabl with the name you provide on the current sheet if you omit the sheet reference.

The other way would be to get the Stats and Data tables the way you like, then duplicate the whole sheet by selecting the existing sheet, then use the menu item "Edit > Duplicate". Then add in your specific data

yopmaster wrote:

...

I would like to do the the same for a set of cell or, even better, for a whole table. That is, I would like to be able to copy the table "Stats" from "Sheet1" to "Sheet2" and having the pasted array to refer to the data in "Sheet2" (instead of "Sheet1" by default)

- Antoine

Then, copy the entire sheet and paste it into the Sheets Pane, and edit out the parts that you don't need from the first sheet. That was Wayne's suggestion. You have to decide which way is the least trouble.

Jerry

YM,

Without getting into why you want to do this, we can just talk about the difference between copying cells and copying the content of cells.

The way to make it paste simply

=2*Data::A1

So that the formula will refer the the table "Data" in "Sheet2" and not "Sheet1" is:

Copy the expression text in the formula editor, from the "donor" cell and Paste in to the formula editor for the receiving cell.

If you simply select the cell and copy it, pasting onto another cell, you will get the inferred relative addressing. If you copy from the formula editor line, the copy/paste will be literal.

Jerry

"I would like to do the the same for a set of cell or, even better, for a whole table. That is, I would like to be able to copy the table "Stats" from "Sheet1" to "Sheet2" and having the pasted array to refer to the data in "Sheet2" (instead of "Sheet1" by default)"

Presented as an alternate to suggestions above. Use is situations where this is the more efficient path.

Omit the sheet name for the formulas if they refer to cells on the same sheet as the original formula in on.

Select all cells in the block you want to copy and set the cell format to Text, using the inspector.

Copy.

Select the top left cell of the similar block in the target table.

Paste.

Reset to cell formats to Automatic (if appropriate) or to the format needed for each cell or group of cells (both tables).

Regards,

Barry

http://www.mac-forums.com/forums/os-x-apps-games/178569-numbers-transferring-dat a-sheet-sheet.html

1) Click in the sheet cell where you want to bring the data to.

2) Press the "=" (equal) key.

3) On the left Sheets panel, click on the table you want to copy the cell from.

4) Click on the cell that you want the data from.

5) Press enter.

Thank you for this concise effective answer!

HI bd,

Concise and effective, yes. But it doesn't answer the original question. Happy to see it helped you, though, and that you took the trouble to mark it "This helped me."

Regards,

Barry