Excel VBA Problem

  • Thread starter Thread starter peterlsw
  • Start date Start date
P

peterlsw

I have a system which adds sheets to a workbook and in the work book
have an analysis sheet. I am trying to generate a average from a fixe
cell on each new sheet which is added to the work book can any on
help.


Thought I could just enter a formula in the analysis sheet to say al
sheets cell b2. to generate some kind of sum.

I need to add each value and then divide it by a set field which I hav
called (no
 
Back
Top