iPad2 Numbers functions

[Numbersnewbe]

What function must I use to copy (link) a totalled number (cell address) from one worksheet to another cell position in a different worksheet? In other words as I enter data in one worksheet I want its total to be carried across to another worksheet for consolidation purposes.

[Sponsors]

[Tim SPRACKLEN]

I don't know the answer to your specific problem (I'm sure other Members will be along soon) but I wonder if you've seen the iPad's iWork's Help pages....


Apple - Support - iOS Apps - Welcome

Tim

[twerppoet]

Go to the worksheet that you want the information echoed in.

Double tap the cell where you want it to apper. This enters editor mode. Select the = sign to enter formula mode.

Navigate to the worksheet where the formula/data already exists and tap on the cell containing the formula.

You'll see the complete path to the cell entered in the editor. Tap on the checkmark to the right to enter the data.

When you go back to the receiving worksheet you should see your value.

[Numbersnewbe]

Thank you for the advice - really easy when you know how! My financial worksheets are now all in sync thanks to you!

[twerppoet]

You're welcome.