Jim Hewson
JHewson at karta.com
Thu Mar 15 09:08:48 CDT 2007
What I would probably do is... Insert a row in each worksheet, then select E1. Sum column E from E2 to say E200 (what ever row would be the maximum plus 50 for good measure). Take E1 from each file and sum them. I would probably copy the value and paste it into a worksheet and work from there. HTH Jim jhewson at karta.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Ervin Brindza Sent: Thursday, March 15, 2007 3:21 AM To: AccessD at databaseadvisors.com Subject: [AccessD] Sum a column in Excel files in a specific folder Hi, I have a couple of xls files in some folder and need to sum exactly the column E in every of them. The number of rows isn't the same in these files. Can somebody help me? TIA, Ervin -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com