Creating a report using date ranges

I have created a very simple sheet to capture mileage logs which records the information in the 'Data' sheet.

On the 'Reporting' sheet I want to be able to but in a month/year and be able to generate a report which shows the transactions for that month/year and calculate the amount to be reclaimed for mileage.

Which is Column K multiplied by column J or K from the 'Data' sheet. If the cumulative miles in a tax year which runs 6th April to 5th April each year is in excess of 10,000 miles then column K should be used for the calculation on miles in excess of 10,000.

I just cannot think of the best way to take this forward. Any help is greatly appreciated.

Looking at your code you really should restore ScreenUpdating to True at the end of the code.

As you have Excel 2010 you can use the Tables feature & the new SUMIFS functions