Automating cell copying from one Numbers file to another

Question

Bartlett2025 Author

Level 1

4 points

Automating cell copying from one Numbers file to another

I have two separate files in numbers. First one is "Pay Details". The second one is MTG Pay Details.

The "Pay Details" is from an email I receive from the company. I just copy and paste all the cells from the email into file number one.

Then I take certain information from first file and copy it into the second file. For example, the first file has columns for "Amount" "Deal Distance" "Additional Pay" "Miles to Pay" "Miles Pay" "Total Pay". I then have corresponding columns in the second file.

My question is: Is there a way to have the values in the cells on first document automatically populate on the second document.

ex.) First document "Amount" automatically transfers to Second document "Amount".

[Re-Titled by Moderator]

MacBook Pro 16″, macOS 15.2

Posted on Jan 12, 2025 12:02 PM

Reply

Answer 1

Top-ranking reply

Yellowbox

Level 7

21,939 points

Jan 12, 2025 7:15 PM in response to Bartlett2025

Hi Bartlett,

No. Numbers does not allow one document to refer to another document.

However, Numbers does allow Sheets (Tabs) to refer to other Sheets (Tabs) within the same document.

Put all your data in one document.

Regards,

Ian.

Reply

Answer 2

Camelot

Level 9

58,311 points

Jan 13, 2025 3:22 PM in response to Bartlett2025

At YellowBox points out, there's no way for Numbers to reference cells across documents - all data has to be within the same document.

One option is to paste your data into a specific sheet within the main document. In this way Numbers can pick it up.

An alternative method would be to use a script to extract the data from your email and input it into your main script as needed. A little more work up-front, but likely pays off long-term.

Reply

Automating cell copying from one Numbers file to another

Similar questions