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