I am trying to create a workbook for use by 5 different employees that will
track the amount of miles each employee drives during work for purposes of
reimbursement. Each worksheet will be for a separate employee. On the
worksheet I need to have the following columns: Date, Description of travel,
Start, End, Mileage (I will also have a column for the running total mileage,
but that is separate from this question). To make it easier for them to
input this information, i would like the worksheet to automatically calculate
the mileage to and from common locations. For example i would like the user
to be able to select in the start column either work or home and in the end
column a range of 10-15 locations (these location in the End column will be
the same for each user). I don't know how to set this up. How can I have
excel calculate mileage based on the selection of home or office and the end
location, and even more complicated...how can i have this setup since the
distance for home to any location will be different for each employee. Is
there a simple way to do this or would it be easier to create separate
workbooks for each user. The benefit of having all users work in one
workbook is that I will be able to have access it all at once and create
charts/other reports without having to switch between workbooks. I know this
is complicated and don't know if there is even a solution...but thanks in
advance for any and all advice.