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.
Last edited by smart_as; 07-08-2011 at 06:53 AM.
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
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
Hi RoyUK that was very helpful and I have now completed my spreadsheet using SUMIFS which I had not used before. So thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks