A
Angela
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!
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!