Calculating data from other Worksheets

Ribice

New member
Joined
Jul 29, 2013
Messages
4
Reaction score
0
Points
0
Hey there,

I have no experience with Excel programming, but with help from another person I'm close to the thing I need.

Basically a machine sends an email with excel report once a day. Customer asked me to make excel file to calculate the monthly data, as easily as possible (for the customer).

Currently I have a file that imports all the files in folder into one excel Workbook with lots of sheets.

There is an empty sheet called Summary, and it has to do certain calculations but I don't know how to make it. Basically it will calculate things from other Worksheets.

You can download the Master file and example files (I had only one, altered it a bit to get second) here (dropbox.com/s/u32x62c6bl2db6h/excel.rar)

If you need any additional info, please let me know.
 
Back
Top