See this page Raj
http://www.rondebruin.nl/summary2.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Raj" wrote in message ...
And a bonus shall be if we can give the user the flexibility of selecting the
folder in which the files are saved and the program considers all the files
in the selected folder. This would be something great.

regards
Raj

"Martin Fishlock" wrote:

Hi Raj

It really depends on how you want your data.

Do you want the sum to be a direct consolidation of the the cells as in

a1=north.xls!sheet1.a1 + south.xls!sheet1.a1.....

Or a totals line report

a1=North
b1=north.xls!sheet1.a50
a2=South
b2=south.xls!sheet1.a50

You then decide if you wnat the links hard coded or done with VBA.

I find the easiet way is to have sheet with a list of the files and you then
go through the list updating each sheet and then you have a control list to
display done or error.



--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Raj" wrote:

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