ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can mulitple Excel workbooks be summarized into 1 workbook? (https://www.excelbanter.com/excel-discussion-misc-queries/236992-can-mulitple-excel-workbooks-summarized-into-1-workbook.html)

micjil

Can mulitple Excel workbooks be summarized into 1 workbook?
 
I have multiple Excel workbooks and need to extract the data from certain
cells in order to sum the cells into a summary workbook. Can this be done?

Luke M

Can mulitple Excel workbooks be summarized into 1 workbook?
 
Probably. Take a look at Ron's site:
http://www.rondebruin.nl/tips.htm

specifically, his article on "Merging Data from Multiple Workbooks"
http://msdn.microsoft.com/en-us/library/cc837974.aspx

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"micjil" wrote:

I have multiple Excel workbooks and need to extract the data from certain
cells in order to sum the cells into a summary workbook. Can this be done?



All times are GMT +1. The time now is 12:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com