Referencing worksheets in order

P

PeteJ

I have data spread out across multiple worksheets. I want to create a
"rolling" summary of some of this data, in that any given worksheet
summarizes data from a fixed number of earlier worksheets. Is there a
way to create a calculation that looks for the previous "N" worksheets
in the order they are listed in the file? I don't want to use their
absolute names, since each sheet will have the calculation and I would
have to edit it each time I add a new sheet.

Thanks in advance,

- Pete
 
D

Dave Peterson

If you only want one worksheet that rolls(?), I think I'd do this:

insert two new worksheets (Begin and End)

put them where you want them in relation to the "rolling" worksheet.

then you can use:

=sum(begin:end!a1)

And then you could drag worksheet in and out of that grouping whenever you
wanted.
 
Top