LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I'm using the mileage log., How do I total all the mileage? ricaislandgirl New Users to Excel 2 April 2nd 07 11:35 PM
mileage john14310 Excel Worksheet Functions 2 June 8th 06 01:16 AM
Gas Mileage Lacreeda Excel Discussion (Misc queries) 5 May 14th 06 03:49 AM
Gas Mileage Patsy Excel Worksheet Functions 4 May 11th 06 05:57 PM
using excel how would I create sheet for adding mileage? Coop Setting up and Configuration of Excel 1 January 22nd 06 07:05 PM


All times are GMT +1. The time now is 02:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"