Macro needed in place of array formula

[Wguru]

Hello,
I would like to write a macro that will do the following for me:
I have two separate worksheets, one containing raw weather data i.e date/time, temp etc in separate columns. The other worksheet is a summary table with date, max temp, time etc in separate columns. I wish to write a formula of sorts to find the max temp using the date as a reference. I will try to explain this further.
Worksheet 1 has date/time in one column, temp in another. The data relates to each minute of every hour of every day. Worksheet 2 just has date (mm//dd/yy) max temp, time etc. I wish to use the date in worksheet 2 to find max temp in worksheet 1. I wish to find the details for each of these between 09:00 on one day and 8:59 the next day. Is anyone able to point me in the right direction please?

Thanks

Anthony

 

[Wguru]

Anyone have any ideas for this?? Record a macro and adjust the code created from that??