Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
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 |