Creating a report to show Vehicle Tax Due.

[james118]

Dear All,

I work in a small haulage company, with a fleet of around 50 Commercial Vehicles, my job there is to Tax and Service and MOT the vehicles when necessary.

I have started to create a spreadsheet file in Excel which has a worksheet for each vehicle registration we have in our fleet. Inside the worksheet is a history of the taxing of the vehicle, this includes the date it was taxed, how long for and for how much, it also has a date of when the tax expires.

I want to create a report on the spreadsheet where i can simply select a month in that year and it will show up all the vehicles which will require taxing before that month is over.

for Example :-

This April we have 5 vehicles which will need to be taxed prior to the end of April.

I want this report to show these 5 Vehicles via vehicle registration number.

This would indeed save me alot of time and effort as i wouldnt have to go through all the necessary paperwork to find these relevant dates.

Here is the example :-


Any help would help would be much appreciated!

many thanks!

exampletax.png