Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying a formula
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying a formula
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. "JFO" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying a formula
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" -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "JFO" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy formula result (text) only - without copying formula | Excel Discussion (Misc queries) | |||
Copying formula | Excel Worksheet Functions | |||
copying the Hyperlink function result without copying the actual formula | Excel Worksheet Functions | |||
copying a formula | Excel Discussion (Misc queries) | |||
copying formula | Excel Discussion (Misc queries) |