kvierra808

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.

Screen Shot 2016-08-30 at 5.13.39 PM.png

 

It would save me time from copying or re-writing each name on separate sheets

Posted on Aug 30, 2016 8:18 PM

Close

Q: Is there a formula that can be used for a column in one sheet, that can automatically input data entered on another sheet?

  • All replies
  • Helpful answers

  • by Yellowbox,Apple recommended

    Yellowbox Yellowbox Aug 31, 2016 3:39 AM in response to kvierra808
    Level 6 (10,430 points)
    Mac OS X
    Aug 31, 2016 3:39 AM in response to kvierra808

    Hi kvierra

    Screen Shot 2016-08-31 at 6.08.31 PM.png

    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.

  • by kvierra808,

    kvierra808 kvierra808 Aug 31, 2016 11:51 PM in response to Yellowbox
    Level 1 (4 points)
    iWork
    Aug 31, 2016 11:51 PM in response to Yellowbox

    Thank you so much for your assistance, this truly made my work so much more efficient and easier.