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 |
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 |
All times are GMT +1. The time now is 05:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com