Creating Summary page in Excel

I am trying to create a sheet at the end of my Excel workbook that will essentially be a summary of all date in the workbook.

I have a Matlab script that takes raw data and converts it into a series of N worksheets that represent the n number of files. The script also produces charts.

I just need to take all of the sheets and average them out as well with the script. Please help me start this.

Thanks :)

Answer 1

[Image Analyst]

You already have the data, since you wrote it out to the individual worksheets. So just do the averaging in MATLAB like you'd expect, and write out another worksheet just like you did all the others. I guess I'm not sure why you don't know how to do this already since you obviously already know how to program in MATLAB and possibly ActiveX, and you already know how to create workbooks and worksheets.