Hi
hope you can help me!
is there a formula which allows me to update a cell in a different worksheet
in the same workbook, with the latest/highest value entered in a different
worksheet?

example:
worksheet B has got chronological listing of mileage related to different
vehicles and drivers.
in worksheet A I like to have the vehicle in cell A2 with it's latest
mileage reading in cell B2, where the criteria will be cell A2.

phew hope this makes sense!

many thanks, Resi