Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum data from multiple Workbooks.
Is there a way to sum data from multiple Workbooks? I need to sum a cell
from multiple Workbooks to get a yearly total. Unfortunately, the person who entered the data made many (200+) Workbooks rather than just adding another worksheet to the existing workbook. I believe I can use the 3-D reference formula but Id need to get all the data into one Workbook. If I already had all the data in one Workbook, I would not have a problem. But€¦ Any help would be/is greatly appreciated. Steve |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum data from multiple Workbooks.
Hi Steve
but Id need to get all the data into one Workbook. Try this http://www.rondebruin.nl/summary2.htm Or http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Steve" wrote in message ... Is there a way to sum data from multiple Workbooks? I need to sum a cell from multiple Workbooks to get a yearly total. Unfortunately, the person who entered the data made many (200+) Workbooks rather than just adding another worksheet to the existing workbook. I believe I can use the 3-D reference formula but Id need to get all the data into one Workbook. If I already had all the data in one Workbook, I would not have a problem. But€¦ Any help would be/is greatly appreciated. Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data aggregation with multiple workbooks | Setting up and Configuration of Excel | |||
etract unique data from multiple workbooks after extracting data | Excel Programming | |||
Taking data from multiple workbooks? | Excel Programming | |||
edit data in multiple workbooks | Excel Programming | |||
Data in multiple workbooks | Excel Worksheet Functions |