LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Get the total sum from various files

Hi to everyone,

I think that my demand it's probably very known, but I've look everywhere on
Internet and I could not find a solution for this problem so I'll appreciate
any help.

Every day I save a Excel file with the date of the day like 16.11.2005.xls,
17.11.2005.xls and so on with texts and numbers on the cell's. I would like
to create a unique Excel file that could read every excel "day" file on the
folder and eventually on subfolders to get the total number on a new excel
file.

Example : on the file 16.11.2005.xls, cell A2 there is a total number of 250
and on the file 17.11.2005.xls, cell A2 there is a total number of 300

On the file that I would like to create "GlobalAmountForThisMonth.xls", the
total sum of every day should be 550 on cell A2.

Thanks in advance for your help.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Duplicate Running Total Grand Total In Pivot Table Mathew P Bennett[_2_] Excel Discussion (Misc queries) 1 August 17th 08 03:13 AM
Excel 2002 : Any single button to get sub total and grand total ? Mr. Low Excel Discussion (Misc queries) 2 May 22nd 07 08:46 AM
calculate count on 2006 total, 2005 total, etc... Amanda Deshotel Excel Worksheet Functions 6 September 28th 06 11:59 PM
% of Running Total to Grand Total in Pivot Table David Excel Programming 0 August 17th 05 08:24 PM
Adding Data Using Multiple Worksheets to Total into a Grand Total Lillie Excel Worksheet Functions 1 April 19th 05 08:34 PM


All times are GMT +1. The time now is 09:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"