I'm new to AppleScript, and I'm trying to find a way to use it to copy a value from one Numbers spreadsheet and paste it into another file.
The situation is that I've been using Numbers to run a personal budgeting spreadsheet, which has worked fine for many months. However, I've recently moved in with my partner, and so we've created another Numbers spreadsheet for joint costs (electricity bills, shopping trips etc). This joint file is shared between us, and so I can't set it up as an additional tab on my existing budgeting file.
I know that Numbers formulas cannot reference cells in other files, so I'm hoping I can use AppleScript to automate this instead. I'm trying to copy the current monthly balance from the joint file to my personal one. I've already used SUMIFS and a few date formulas to provide a monthly total in the joint file (so the value I want to 'export' will always be in the same cell), and I'll be able to create a specific cell to 'import' into on my personal file.
So my problem is simply getting AppleScript to copy a value is a given cell and paste it into another given cell in different file.
Is this possible?