I need to create an automated macro to find the minimum values of recurring
row sets with a space in between the sets such as:

Max Distance = 8100
Min Distance = 7900

Time Distance
00:33.1 8075.000
00:32.8 8083.000
00:32.7 8084.000

01:52.3 8878.000
00:33.4 8073.000
00:23.0 6798.000

00:12.2 4478.000
00:33.3 8092.000
00:33.2 8084.000

but these values must meet criteria from the min and max distance column.
Once I find the minimun time, I must take data from the corresponding row and
paste into a formatted worksheet.

Thanks for any help you can provde....you guys are a blessing.