Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get the total sum from various files
You can run a macro like this to make the links
http://www.rondebruin.nl/summary2.htm Or if you only want the values http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl "LLOYS" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
Excel 2002 : Any single button to get sub total and grand total ? | Excel Discussion (Misc queries) | |||
calculate count on 2006 total, 2005 total, etc... | Excel Worksheet Functions | |||
% of Running Total to Grand Total in Pivot Table | Excel Programming | |||
Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions |