Hi guys!

I have a workbook containing 13 worksheets - 12 worksheets containing the monthly sales figures which are named January through to December and 1 worksheet to summarise the annual figures.

I am trying to find the highest value in cell C14 across all 12 monthly worksheets and then display the worksheet name as the result....is this possible?

I am also trying to do exactly the same as the above but display the actual figure of the highest amount rather than the worksheet name.

Any advice on these two issues would be very much appreciated.

Thanks in advance.

Darlo