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.
Csound1 wrote:
Thanks.
You can have any number of Tables on an Excel sheet, hundreds if you're crazy enough. 🙂 in my workflow a new venue starts with about 8 tables on a single sheet, then morphs into a multi sheet workbook as ancillary and reporting sheets are added. Excel can operate like Numbers, or Excel, or both at the same time. That's as it should be, it costs a lot more and has a massive user base, all complaining about something 😎
Excel's tables are "in the grid" making it tough to do something like this (the Numbers 3 Calendar template):
This is constructed from four tables on one sheet.
SG
But where are the other three tables in your example? In the Numbers template, aside from the main calendar, contains a table displaying the previous month and another table displaying the subsequent month, both "in miniature" in a nice presentation right above the main calendar. (The fourth table displays month and year, and contains hidden cells with the guts of the calculations.) Tough to produce such a nice, compact display on one sheet in Excel, without going through contortions. It's easy in Numbers 3.
SG
I don't need them so I don't use them, if I did they would appear in the same place, too cluttered for my liking 🙂 But if I did I would not bother going through the complications of the all in one approach, I would use a separate sheet(s) as required to provide data for the calendar. That makes it easier to just print a calendar without the bother of not printing the calculations.
(I suspect that using Numbers I would also put secondary and calculation tables on a separate sheet, it looks to be exactly the same in that respect, but without Excels ability to define a print range)
Ignoring the hidden calculations (they can easily be put elsewhere if desired, in either Numbers or Excel) Excel cannot easily deal with multiple tables on one sheet for easy printing, unless the tables all align on the same grid. That "everything in the same grid" is an inherent design limitation from the old days.
Numbers, with its tables "anywhere on a canvas" design, is much more powerful in that one respect. It can do some things easily that would be very tedious in Excel... if possible at all.
SG
SGIII wrote:
Ignoring the hidden calculations (they can easily be put elsewhere if desired, in either Numbers or Excel) Excel cannot easily deal with multiple tables on one sheet for easy printing, unless the tables all align on the same grid. That "everything in the same grid" is an inherent design limitation from the old days.
Excel allows simple selection of a Print Range, that is the way you would do it, The tables can be randomly scattered and you could still print each one separately. Using multiple sheets is even simpler.
Csound1 wrote:
Excel allows simple selection of a Print Range, that is the way you would do it, The tables can be randomly scattered and you could still print each one separately. Using multiple sheets is even simpler.
The tables can be randomly scattered in Numbers too (and, unlike Excel, not tied down to one uniform grid), and you can use multiple sheets in Numbers too.
But in Numbers you don't have to go through those contortions to produce that particular sophisticated visual display with minimal effort. It's an inherent advantage of the "tables anywhere" on the canvas design.
SG
Sorry, you have lost me, Excels tables can be placed anywhere on a sheet, I do it all the time, grid alignment does not dictate where you put them. They can be designated as printable regions simply by selecting one or more and designating that selection as at the print range (one click) Where are these 'contortions'
Just stopped by to check the title of this thread. Oh, it's
how do i share a value between to numbers spreadsheets
Thats right.
q
Perhaps you can answer this question then?
Hi quinn,
The original question is ambiguous (perhaps a result of confusion about Numbers terminology that is similar to other spreadsheet apps but also different) and the OP hasn't provided clarification and enlightened us.
So there is no harm to some free-form discussion about other commonly misunderstood similarities and dissimilarities between Excel and Numbers, is there?
SG
And I am asking a (slightly) related question, in the example I posted how would I select which Table to Print, I know how to do it in Excel (and by extension Libre and Open Office) but how is that accomplished in Numbers?
Csound1 wrote:
Sorry, you have lost me, Excels tables can be placed anywhere on a sheet, I do it all the time, grid alignment does not dictate where you put them.
On my machine, Excel Tables are integrated into the underlying grid on a sheet. Change a column width or row height on the sheet and all tables that span that column or row are affected. That's a big design difference (and a frustrating limitation) compared to Numbers tables that can be placed on a canvas and dimensioned independently.
SG
Csound1 wrote:
how would I select which Table to Print, I know how to do it in Excel (and by extension Libre and Open Office) but how is that accomplished in Numbers?
The best way to print a specific table (a workaround, but an efficient one that works well here) is:
SG
how do i share a value between to numbers spreadsheets