Extracting Group of Data from Defined Criteria

[Yiyi]

Hello,

I have a worksheet with data containing, Start Date, Visit Date, Vehicle No. and Turn/Call. I also have another worksheet where I select a criteria and have results returned based on the criteria chosen. To illustrate:

Start Date Visit Date Vehicle No. Turn/Call City
01/01/11 01/01/11 2 T Miami
" 01/02/11 " C Ft Lauderdale
" 01/03/11 " C Boca Raton
01/04/11 01/04/11 " T Miami

Criteria_Rng:

Start Date: 01/01/11
Vehicle No: 2

Results:

No. of Visits: 2
Route Length: 3 days
Route Identifier: Miami/Ft Lauderdale/Boca Raton/Miami

Start Date Visit Date Vehicle No. Turn/Call City
01/01/11 01/01/11 2 T Miami
" 01/02/11 " C Ft Lauderdale
" 01/03/11 " C Boca Raton

Any assistance or ideas is of great value.

Thanks
Yiyi

 

[PCRIDE]

This is a full dashboard, to make it easy send me a sample. I tried typing it but just took too long.