Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I consolidate one work sheet from several workbooks? A few oth
Hello,
I have several workbooks. In each workbook are several worksheets. All worksheets in all workbooks are identical. Each workbook contains one Roll-Up worksheet that consolidates all the worksheets in the workbook. I need to consolidate all of these consolidated worksheets into a new workbook. How can I make this happen? When I use the consolidate feature, Excel tells me, "No data conslidated" Any thoughts? Can I refresh my conslidated workbooks? Or does using the consolidate feature require that it be recalcuated every time the various worksheets change? All my calculations are conducted by each worksheet. Only raw data needs to be consolidated. I have a particular data range for this. I did this because I'm afraid of rounding errors generated by summing calcuations, versus one single calcuation. Is that logic sound? Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to merge monthly workbooks into a quarterly workbook?? | Excel Worksheet Functions | |||
macro | Excel Discussion (Misc queries) | |||
Sum up columns in different sheet with error check | Excel Discussion (Misc queries) | |||
Sort data from 1 work sheet into another | Excel Worksheet Functions | |||
How to copy the work sheets from different workbooks into one? | Excel Discussion (Misc queries) |