Average range of data based on user input

I have a sub that finds a time value that matches a time input by the user. The user also input the number of rows prior to and after the first occurrence where the time is found in the data set. I would like to average the values for each data point in the specified time range and paste these values to a different worksheet. I have attached a document with a respresentative data set.

Example: User inputs 9:32, and specifies that 3 cells be used for the average.
The sub finds cell A6 and sets the limit values 3 above (A9) and below (A3). For each data set (Data 1, 2, 3 etc) I want to get the average between A3 and A9 then enter this value onto a different worksheet

Here's a possibility.

Please Login or Register  to view this content.