Extracting Maximum values of a column base on the multiple ranges in rows

Dear all members,

I am so new to VBA and I am quiet busy with writing a program which enables me to sort out my huge data files. Actually, I have done some compression test on a piece of tissue and I obtained my output excel fine which you can find in the attachment. the compression test was applied in a cyclic manner so in column "E" you can see the number of cycles and in column "H" there are related load values.

I want to extract the maximum load of each cycle (for example the first cycle has started from "E54:E553" and I want the maximum load of this range which is in the range of "H54:H553") and copy that number and put it in the "S" column from sequentially. I did this sample manually but it would take me much more time considering the large amount of data in some of my experiments.

So I think the program should be capable of determining the range base on the number of cycles (as a variable here) and also be able to stop the loop once the last row of the last range (for the last loop) becomes " " (empty cell). Here I have 5 cycles so I would expect 5 maximum value of Load. Btw, the cycle would start from "E54" and the first few seconds there is no compression. so that's my protocol and I cannot change it, but if you think it makes it more easier to separate the starting point of cycles then please let me know.

I would highly appreciate any help. Please provide some details of program description if it's possible. So many thanks in advance.

Sepanta

Hi

Thanks for reminding me this point.actually it may vary depending on my test protocol .so the number of rows (number of cycles) may change to a higher or fewer amount.that's why I said the program has to stop once the last row of the last cycle reaches to " " .

Regards