Re: Milage Report
Try using the attached file. I've created dynamic ranges "Mileage_Table", "From_City" and "To_City", and set up validation cells (drop-downs) on each row on sheet "2009" (cols C and D). Finally, mileage in column G is calculated via INDEX/MATCH formula. This might be a simpler solution to writing VBA code to do what you need.