Filtering details onto a different worksheet

[Finalfrontier1976]

Hi guys,

A somewhat complicated one for me.

I have a huge spreadsheet (attached) on it is a list of all my vehicles, what I want to do is somehow get a macro that will check the whole sheet and look for entries of unrecorded mileage (for example see line 1228) for each vehicle.

What I would like it to do then is on another sheet in the workbook is draw out all the entries so that the new sheet will show the following:

The registrations of the vehicles that have unrecorded mileage (if we use the example on line 1228 you will see that on line 1223 is the vehicle registration)
The date before the unrecorded mileage and the date after for each registration with unrecorded mileage (with the driver name)
The unrecorded mileage amount (the entry on line 1228 for example)

I'm not sure if all this can be done. The report this data comes from would be generated weekly so the length of the spreadsheet will increase or decrease so can the macro allocate for that by looking at the whole sheet rather than a specific range.

Any suggestions would be great!

Thanks,
Lew