I am using this sheet as an example

http://homepage.ntlworld.com/george....%20example.xls

the data contains date/time info in column A and weight data in column B which cycles for when a tank is filled and subsequently emptied (indicated by values below 100)

I am looking for a script that will:-

a. identify these cycles using the column b data and seperate out or return the date/time values for cycle start and end
b. report the max value in column b for each cycle

The max value of b data will allow me to know which product was in the tank. I will then know the date/times for each time a particular product was made. I then want to extract the data from the rest of the columns for the specified dates

I am hoping this sounds lot more complicated than it actually is but I am completely lost when it comes to programming VBS and macros so I desperately need some help.

Thanks.