Data transfer

[ADMfocus]

Hi All,
I am a new member of the forum and a basic user of Excel 2007 and 2010 starter. I would very much like some help with the following. I keep a data base record of the daily weather, Rain, High/Low Temp, Wind etc. The days/months in rows, data in columns with totals/averages at the end of each month. The totals/averages are hyperlinked to Sheet 2 which gives me the month by month data. What I would like to be able to do is, pick the highest days rain fall for each month and send it to a designated cell on Sheet 2. So, if 12 mm (cell E5) was the highest value for January on Sheet 1, I would like it to appear in say cell M13 on Sheet 2.
many thanks

[Kaper]

You have two options - if you really want to "send" the result to some cell you shall use VBA to loacate the desired value and store it in Sheet2. But may be it is enough to use some formula in M13 in Sheet2, which locates appropriate value in sheet1 = not seeing your data it is not easy to suggest the formula. May be as simple as:
=MAX(Sheet1!E2:E32)
would be enough.

The good concept to check for quick analysis of (even quite large) datasets is a Pivot Table
As you look for average an/or max/min values for some data in specific periods (months) it seems perfect.
See attachment

[ADMfocus]

Many thanks for quick replay, will give suggestions a try and let you know.
Regards ADM

[ADMfocus]

Hi again, the "=MAX" etc. works. Thank you.
Not worked on Pivot Tables but will give it a try.
regards
ADM