how to average a cell value across worksheets?
Hello,
I have a workbook containing upto 30 worksheets, i.e.
at any given time there could be any number of sheets
from 1 to 30
I'd like to have a function which would average values
in one particular cell across the sheets prior to the call
(from sheet1 to the sheet where the function is called).
Could somebody please get me started on this one.
Thanks in advance,
Mark
|