Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Perform a calculation on same cell across many worksheets
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)? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Perform a calculation on same cell across many worksheets
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 On Mon, 7 Jul 2008 13:06:01 -0700, Pat Adams wrote: 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)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to perform matrix calculation in excel? | Excel Discussion (Misc queries) | |||
perform a calculation when a certain phrase appears in a cell | Excel Worksheet Functions | |||
Perform calculation from drop down list | Excel Worksheet Functions | |||
comparing two columns & then perform a calculation | Excel Worksheet Functions | |||
perform calculation only if current time is after 10 am | Excel Worksheet Functions |