View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lt[_2_] lt[_2_] is offline
external usenet poster
 
Posts: 6
Default Aggregating data from various file in one.

I have a set of data files with the same format that I would like to
add up in a summary excel file. So for example, I would like to add
all the A1 cells of all the sheet1 worksheets of all data files to cell
A1 of the sheet1 worksheet of the summary file. How can I do it?
Thanks in advance for any help.