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
 
Hi Peter,
Something like =SUM(Sheet1:Sheet3!A1) to add them all up
Bernard
 
You must log in or register to reply here.

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

Excel Move or Copy Stopped Working? 0
Excel, assign cells in multiple worksheets from one sheet 1
sum 1
Ignoring Blank cells 9
excel sheet name 2
same formula and cells for different worksheets 1
Excel lookup across entire workbook 1
VBA Macro - Copying specific data to different sheets in a workbookand linking the InputBox to a com 7

Back
Top