View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Deepak Deepak is offline
external usenet poster
 
Posts: 47
Default calculating valuses from all sheets

I have single workbook with 31 sheets on it (all sheets has diff. names on it)

all the sheets have some values in A8 & A9 (maintained position)

what i want is on the first sheet in cells A8 and A9 I need the average from
all the other sheets from cells A8 & A9

Sheet 1 = A
Sheet 2 = B
Sheet 3 = C
Sheet 4 = D

so Cells A8 & A9 in "Sheet A" - should have the average from "Sheet B" A8 &
A9, "Sheet C" A8 & A9, "Sheet D" A8 & A9,

I hope i didnt confuse

thanks in advance