Our employees need to record mileage between buildings. We have a workbook
with two sheets; daily travel and mileage grid of distances between
buildings. On the daily travel sheet they put in building codes (From-To)
and get the mileage from the grid. I'd like to automate it so when the
From-To codes are entered, the mileage from the grid is automatically
entered. Example: A1=BldgA B1=BldgD C1=mileage from grid. ....Note: A
Format Control on a form works, but there are several dozen entries, so this
is too cumbersome.