Using multiple sheets in Numbers on iPad

You can copy values from one Table to andother table using a formula in the receiving cell of the second Table. The tables may be on separate sheets. The formula can be as simple as a cell reference to the source Table.

Example: Source table is Table 1 on Sheet 1 of your document. Receiving table is Table 1 on Sheet 7 of the same document. You want to copy the contents of each of the five cells in Row 3 of the source table to Row 3 of the receiving table.

On Sheet 7: Click A3 of Table 1 to select that cell, then type = to open the Formula Editor.

Click the left end of the Formula Editor to select it, and drag down to uncover the cells in Row 3.

Click the tab for Sheet 1 to see that sheet. The Formula Editor will follow you there.

On Table 1 on this sheet, click cell A3. The cell address (Sheet 1::Table 1::A3) will appear in the Formula Editor.

Click the green check mark to confirm the formula, close the editor and return to Sheet 7.

On Table 1 of Sheet 7:

A3 should now contain a copy of the value in A3 of Table 1 of Sheet 1.

IF Column A is a Header column, click once on A3 to select that cell. Copy. Click once on B3, and Paste. Continue to next step, using B3 as the starting point.

IF Column A is NOT a Header Column, hover the pointer near the right boundary of cell A3. Grab the yellow circle that appears on that cell boundary and drag right to fill the rest of the row.

With the row now filled with copies of the formula, each displaying a copy of the information in tht cell's sister cell on Table 1 of Sheet 1, IF A3 is not part of the selection, command-click on A3 to add it to the selection.

With all cells in row 3 now selected, hover the pointer near the bottom boundary of the cell closest to the middle of row 3. Grab the yellow dot handle and drag down to fill the formula into the rest of the cells in the receiving table.

Note that this is a one-way process. Changes made on the source table (here, Table 1 of Sheet 1) will be copied to the receiving table (Table 1 of Sheet 7). Changes made manually on Table 1 of Sheet 7 will replace the copied value in the cell that is changed, and will NOT change values in the Source table.

Regards,

Barry