I receive test data from a subcontractor. However, the received files are essentially unusable, since they are not in a user-friendly format. I need a visual basic script written that will perform a macro on many (thousands) of excel worksheets, merge the files and then perform some basic statistics on the resulting file. Note that each file contains data on approximately 20 parameters.
I will need the script to generate histograms for each of the parameter, calculate standard deviation and Cpk's for each of the parameters.