Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summarizing the files in 1 folder to one file
Dear All,
I am in requirement of your expert help. I have multiple files in a folder which have exactly the same formats, Sheet names and structure. I need to summarize the data in a new file extracting the data from each of the files in the folder. For example, each of the file in the folder has one sheet called Sales, so in the desired file I want to have the result as summation of sales from individual files. The file are named on the basis of the regions so they do not have any consistency. Formulae or a macro to enable me doing the same would be of great help. Thanks in Advance Raj |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summarizing the files in 1 folder to one file
Have a look at Rons pages he
http://www.rondebruin.nl/ado.htm and here http://www.rondebruin.nl/copy7.htm Corey.... "Raj" wrote in message ... Dear All, I am in requirement of your expert help. I have multiple files in a folder which have exactly the same formats, Sheet names and structure. I need to summarize the data in a new file extracting the data from each of the files in the folder. For example, each of the file in the folder has one sheet called Sales, so in the desired file I want to have the result as summation of sales from individual files. The file are named on the basis of the regions so they do not have any consistency. Formulae or a macro to enable me doing the same would be of great help. Thanks in Advance Raj |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i retrieve my excel file from temporary files folder | Excel Discussion (Misc queries) | |||
Summarizing the data from all the files in a folder | Excel Discussion (Misc queries) | |||
Save file in a new folder, but create folder only if folder doesn't already exist? | Excel Programming | |||
How to exctract files listed in an Excel-file from a folder? | Excel Discussion (Misc queries) | |||
how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | Excel Programming |