Thanks very much for your reply sijpie..

I don't need that yellow parts. I only need a summary table. The thing is there will be many workbooks and each workbook might have different number of worksheets. Macro should calculate Minimum,Maximum and 3 quartiles for defined range. Also there is a specific region I call it Z in this case. I need macro to pull the value for Z from defined range and paste into summary table. The other thing is how users would specify the range in the process..As you said marking first and last row of the column might be the preferable option. In that case, if there are some blank rows in that range macro wouldn't get the blank row as the last row of the range would it?

I really appreciate for your help.




Quote Originally Posted by sijpie View Post
Which part of the sheets is to be calculated / generated by the macro? The yellow block? And the user is to indicate the column? Is the macro allowed to put the block in a consistent place (like at least on the same row)? Do you need these yellow blocks at all or can the values be generated on the fly and only the summary table generated?

How many sheets will there be? Do you want to have the macro ask for the column for each sheet or could the user just enter the column letter in a cell (say A1) or mark the column with an 'X' in the first row of the column? (personally I would think the last two options would be preferable over having to select, click OK, select, click OK, etc)