Copying a formula

  • Thread starter Thread starter JFO
  • Start date Start date
J

JFO

I have to prepare a worksheet that summarizes the latest data from about 6
columns in 180 detail worksheets. Any thoughts on how this can be done
efficiently?

JFO
 
Are all these sheets in 1workbook ?? What are in these 6 columns ?? Do you
want to summarize all 6 columns ??

Tell me alittle more maybe I could help you.
 
You need to tell us a little more about the data to be summarized
If I have numbers in B10:D10 of 25 sheets and I want to sum the 25*3 values:
I insert a sheet before the first one with data and call it "Begin"
I insert a sheet after the last one with data and call it "End"
I keep the sheets totally empty
The I can use =SUM(begin:end!B10:D10) to sum all the cells in that range on
all sheets
I might put this formula on a sheet that lives in front of "Begin"
 
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

need help on either doing a loop and counting specific values orusing subtotal function 2
Worksheet formula incorrect after copying to another worksheet 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Summary of Unique item values 2
Excel Moving data to sheet2 from sheet1 0
how to automatically update a second worksheet when data inserted 2
Formula Help 1
Count if or SumProduct 2

Back
Top