We have a series of spreadsheets all with the same structure. In each worksheet there is a series of records pertaining to traffic/vehicle observations passing through a series of locations along a route. The information recorded is Type of vehichle, time, registration numbers and location. We would like to be able to enter two location points from the route e.g. 1 and 5 and the macro should ten list all the vehicles (registration numbers) along with the time recorded/observed in locations 1 and 5 along with the difference in the times.