I have a question about Numbers

[MacDryCleaner]

Hi All -

If I have a list of numbers in one spreadsheet can I have the sum of those numbers show up in another spreadsheet? And, if I change one of the numbers in the calculation I would want the number in the other spreadsheet to instantly update. I know how to do this in Excel but don't know how to do this in numbers.

Please help ....

Thanks!

 

[TreoRenegade]

I'm too new to Numbers to answer this, but I suspect you'll find/get an answer quicker over at the Apple forum devoted to this app:
http://discussions.apple.com/forum.jspa?forumID=1300&start=0

 

[Mac In School]

It depends what you mean by "spreadsheet".

You can cross-reference stuff between tables and sheets within the same document. You can not, however, cross-reference stuff in a separate document.

If you're trying to go between sheets, type your equal sign, then just started typing the sheet name. =Sheet 1, for example. It should auto-fill pretty quickly.

 

[Gregg2]

It depends what you mean by "spreadsheet".

Right.

You can cross-reference stuff between tables and sheets within the same document. You can not, however, cross-reference stuff in a separate document.

And not in Excel either, I think. That would be quite a trick. Document, file, ...I think in Excel, it's called a Workbook. Within Workbook A, you can have Sheet 1, Sheet 2, etc. You certainly can make a calculation on Sheet 1 that updates something on Sheet 2, but I don't think Workbook B will pay any attention to it.