Hi Everyone ,
I need to calculate Quartile 1-2-3, Min/Max values and value for Z in a specific column. There are multiple workbooks and worksheets. That specific column might be different in each worksheet so I need to ask user to select the range which will be used to do the calculations then process would create a summary tab to list the values for each worksheet like a,b,c,d etc.. as shown below.
Workbooks come from different data sources every quarter so I need to use a vba script which would do the calculation in active worksheet for the range selected by user. Would you be able to help me on this?I attached a sample file.
Z Min Q1 Q2 Q3 Max a 48.5 44.7 55.6 61.05 64.725 90.9 b 74.5 61.4 78 81.4 83.1 100 c 24.5 21.9 34.0 39.45 44.9 87.9 d 48 32.5 48.9 53.8 59.7 96.4
