Perform a calculation on same cell across many worksheets

P

Pat Adams

I need to perform a calculation on my master sheet that will be the same and
reference the same cells across numerous worksheets, actually I will have a
series of these things.

Does anyone know how to get excel to continue performing a function until it
gets through all the worksheets and then stop (& not think it has encountered
an error)?
 
G

Gord Dibben

The easiest method is to insert two dummy sheets..........one to the right of
Master and one at the end.

Name them Start and End

In a cell on Master sheet =SUM(Start:End!A1:A10)

Insert any new sheets between Start and End


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why do Excel cells not calculate until I hit "save" 2
Keeping references while changing worksheets 1
Average across worksheets ignoring zero 2
What if scenarios using multiple worksheets 1
VBA for Dependents shortcut menu 0
IF function says too many nested 1
How to autofill the same cell reference across multiple worksheet. 1
how do I referance a data valuation cell from another worksheet 2

Top