iWork
Q: Is there a formula that can be used for a column in one sheet, that can automatically input data entered on another sheet?
Is there a way that if I entered data on sheet, that it can automatically enter the data on another sheet without having to copy and paste?
For example: On each of the 7 sheets I have, the first 5 columns are the same data that I need copied to each new table/sheet.
It would save me time from copying or re-writing each name on separate sheets
Posted on Aug 30, 2016 8:18 PM
by Yellowbox,Apple recommended
Mac OS X
Hi kvierra
I have placed the two tables on the same sheet for clarity (move the entry table to its own sheet later).
Table 1-1 is on one of the sheets where you want a copy of the entry table.
- Click in A2 and type =
- Click on A2 of Table 1
- Press enter
- Fill Down, then Fill Right as far as needed.
- Select Table 1 (click on the bullseye) and Cut
- Go to the entry sheet and Paste. (That moves the table)
- Numbers will automatically adjust the formulas if necessary.
Copy columns 1 to 5 of Table 1-1
Go to the table on each sheet, click in A1 and Paste.
Please call back with questions.
Regards,
Ian.
Posted on Aug 31, 2016 3:39 AM

