I have created 2 Numbers spreadsheets to track my vacation expenses this year. Is it possible to automatically import a value from one spreadsheet into another? They are both in the same workbook, one keeps track of mileage and fuel expenses, and the other keeps track of all other expenses.
Thanks in advance for your help.
-Nancy
iMac, OS X Mountain Lion
Hi Nancy,
To reference a cell on a different sheet or table, when you come to the point in your equatino where you need the address of the remote cell, just navigate to the remote cell and click on it, then continue typing or hit Return if that is the last item in the equation.
Of course you can also just enter the remote address manually. The syntax is Sheetname :: Tablename :: Cell.
If the table name is unique in the document, it is not necessary to use the sheet name.
About the names of things in Numbers - a little different than in Excel.
The entire document is referred to by Apple as a Spreadsheet, just to be consistent with the industry. I believe you called it a Workbook, an Excel term. Most folks here simply call it a Numbers Document.
What you called a Worksheet is a "Sheet" in Numbers.
Within a Sheet you can have multiple Tables, Graphics, Text Boxes, etc.
In Numbers, Tables are treated like Named Ranges in an Excel Worksheet. They should be kept to just the size needed for the data, and it's best to isolate separate collections of data in separate tables.
Regards,
Jerry
Thanks!
That worked perfectly! I had a little trouble, until I realized I needed to put "=" in front, then it worked.
I have one last question......
Will this cell still work when it is opened in the iPad version of Numbers? My conditional formatting doesn't seem to work there.
-Nancy
PS: Thanks for the lesson in terminology. As you can tell, I'm a former Excel user. I actually debated what to call everything, and since I didn't know, I fell back on my old Excel terms.
Nancy,
Yes, every expression, anything other than a literal entry, must be preceeded by the equal sign.
You can ask about the iOS version in the iOS iWork discussion area. I would answer if I knew, but most of us, I would guess, here in the Mac iWork area arean't lucky enough to own iOS devices, and I can't be sure of my answer.
I suggest that you download and read the first few chapters of the Numbers User Guide PDF. It's free and there's a link in the Help menu. Easy to read, easy to use as a reference too.
Jerry
Importing values from one spreadsheet to another
