New Sheet Cells that Automatically get referenced.

Question

Level 1

8 points

New Sheet Cells that Automatically get referenced.

Hi All!

I'm trying to have 50 sheets in a Numbers document, that I want a certain cell in each sheet, say D:18, to be automatically referenced to a total amount. I add new sheets constantly and I don't want to manually click each cell each time I add a sheet. Was wondering if I can add a formula to speed this up. And I've tried using (=sum(First:Last!D18) but as soon as I start typing "First" it brings up an autofill and won't let me type the original formula... Any help?

MacBook Pro with Retina display, OS X Yosemite (10.10.2)

Posted on Mar 5, 2015 7:50 AM

Reply

Answer 1

Mar 5, 2015 8:11 AM in response to bennycaleny

in the summary sheet you can use the function indirect() to refer to other sheets like this:

assuming the sheet number is stored in column A

B2=INDIRECT("Sheet "&A2&"::Table 1::D18")

this is shorthand for... select cell B2, then type (or copy and paste from here) the formula:

=INDIRECT("Sheet "&A2&"::Table 1::D18")

select cell B2, copy

select cells B2 the the end of the column (or however many rows you have), paste

Reply