Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I'm using the mileage log., How do I total all the mileage? | New Users to Excel | |||
mileage | Excel Worksheet Functions | |||
Gas Mileage | Excel Discussion (Misc queries) | |||
Gas Mileage | Excel Worksheet Functions | |||
using excel how would I create sheet for adding mileage? | Setting up and Configuration of Excel |