how do i share a value between to numbers spreadsheets
i would like to share values bewteen 2 spread sheets on numbers
i would like to share values bewteen 2 spread sheets on numbers
Numbers does not allow one to refer to cells in a table of a sheet in a different document (or file). The best solution is to store related information in different sheets.
Numbers does not allow one to refer to cells in a table of a sheet in a different document (or file). The best solution is to store related information in different sheets.
Redundancy of information often leads to errors, because keeping these numbers in synch would turn out to be a nightmare, specially when you talk about sheets with over 50 rows of data.
So I would not call that a "Best solution". It is like when you get hanged 10 inch above the ground versus 10 feet above, it does not make a huge difference and then calling the 10 inch a Best Solution ......
Smiley_sr wrote:
Redundancy of information often leads to errors, because keeping these numbers in synch would turn out to be a nightmare, specially when you talk about sheets with over 50 rows of data.
Err no. keeping numbers in sync is something computers do rather well.
In two numbers file? (Because that is the original question. How to share information between 2 numbers files and that is impossible in the current version of numbers.
I am just addressing your statement that syncing numbers in a spreadsheet would "turn out to be a nightmare" In Numbers sheets are tables and you can sync between tables, it's not a nightmare at all, it's routine.
Additionally the question is about 2 sheets, not 2 files, they are different things.
Please provide a link to whatever evidence you have that shows support for your assertion.
Why do you have to have separate files? If the files are so relatable then it would probably be best to have them in the same document, but in separate sheets.
Please go to the beginning of this thread and read it again, the OP never mentioned 2 files.
Touche Csound, I read the first answer who is talking about 2 files, which is the problem I am having. For having a small administration with members, invoices, and balances. I have no good way to keep everything in synch through the standard iWorks apps. And yes I do have multiple files, not multiple sheets
I Did go back and read th OP, and it is vague. Some people refer to spreadsheets as different documents and others don't. Since you didn't make the OP maybe you should stop posting until that person does.
to the person of the OP. There are a number of ways to accomplish sharing values between two sheets in the same document. To figure out which is best we would need more information.
Re: how do i share a value between to numbers spreadsheets
That's not vague.
Smiley, you should start your own thread, you'll get better attention that way
charles, you have a very different definition of vague than I do
Hi all,
I think the confusion is in how Numbers defines a "spreadsheet". A "spreadsheet" is what Numbers calls a document. Within that document there are "sheets" and on the sheets there can be many tables. This is different from Excel.
If the poster's question is how to share data between sheets of the same document, this is something that is easily done in Numbers. If the poster wants to share data between different Numbers documents then this is not easily done within Numbers. If this is the case, and the poster is committed to keeping their spreadsheets in Numbers then the two files need to be joined or an applescript solution can be used. If the poster needs to keep the documents separate or does not want to use applescript then another spreadsheet program can be used. I am told that Excel and Libra Office may be able to link between seperate documents or spreadsheets.
quinn
Excel and Libre can link cells between different sheets (contained in the same file or in a separate file) Excel can read data from a closed file as well. Libre can do the same.
Excel files are commonly known as Workbooks, they can contain a large number of independent sheets.
Hi Csound1,
I knew I had heard that from somewhere!😁
quinn
It's a little like an American trying to understand, say, Australian!🙂 It seems like the same language, but there are enough little differences to cause misunderstanding.
A Numbers "spreadsheet" or "document" is analogous to an Excel "workbook."
A Numbers "sheet" (tab) in analogous to an Excel "worksheet" or "sheet" (but has a expandable canvas rather than a grid of cells).
Cells in Numbers are always in a "table" whereas cells in Excel can be directly in a "sheet" or in a table in a sheet.
References between cells in different tables (located on the same or different sheets) in Numbers are easy as long as the tables are in the same "spreadsheet" or "document."
References between cells in tables in different Numbers documents is not possible in formulas, whereas references between cells in different Excel workbooks is possible (though probably best avoided in most situations).
It is possible to read and write information between different Numbers documents using AppleScript, but in most cases it is (much) easier to reorganize work so that it is all located in the same Numbers document.
SG
SGIII wrote:
References between cells in tables in different Numbers documents is not possible in formulas, whereas references between cells in different Excel workbooks is possible (though probably best avoided in most situations).
No reason to avoid it either. The system itself is old, well tried and tested. It is simple to name the cells that are linked making the method impervious to worksheet edits, or, as Excel can have multiple worksheets in one workbook you can do it on multiple sheets in the same file (document)
Does Numbers allow cell linking by name? or is it still stuck with by reference only?
how do i share a value between to numbers spreadsheets