Comparing values from three user-selected workbooks and summarizing the results

[g_purve]

Thank you for your time in helping out. I am trying to create a summary sheet that compares results from multiple reports created by automated testing software. I often test the same product multiple times and would like to compare the results in a summary sheet. Each time the product is tested the measurement software generates a standard report which is saved as its own workbook. I am trying to create a summary sheet that would contain the code in order to ask the operator which files they would like to compare from a pop-up window. Then the code would open the selected workbook and copy the measurements of interest ( currently the measurements are listed in the same location within each workbook) and paste them into the summary file. The summary file would have three sets of measurement data, each pulled from a test report selected by the operator, the file name for each test report which measurement data is pulled from would also be listed in the summary file. I am trying to create three sample test reports now and will attach in a follow-up to this post. Thanks in advance for your time and help.

Garrett