View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Angela Angela is offline
external usenet poster
 
Posts: 85
Default Help with a mileage sheet

I am trying to create a mileage sheet, it needs to include a cost center, to
and from and the standatd miles. I have created a document for this to pull
form, but am having problems trying to create the formula. Here is an example
of what I am trying to do.

N. St P. St. X. St
N. St. 0 5 10
P. St 5 0 2

That is on one sheet, I need the data to pull into the other sheet, so if
someone types in

To From Total Miles
N. St P. St (5 - The cell would auto fill with the correct
mileage form the other sheet).

Is there a way to do this? If so, how would I do it? There are approximately
15 different locations on the spreadsheet. Thanks so much!