Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help please
I am trying to automate my weekly travel itinerary, which is an excel sheet.
Ideally I would like to enter the destination into my itinerary, and then automatically have the mileage displayed in another column in the same sheet, and then have another sheet compiling my monthly mileage claim. I sort of realise this will need a sheet to be matched to, i.e one sheet showing the destination and mileage, my itinerary, and then the claim sheet. Reason is that mileage is claimed quarterly, and its a nightmare going over 13 itinerary's and matching the mileage Appreciate it anyone can point me in the direction where I can maybe work it out. Bob |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help please
How complex is your travel?
A few cities or many? How often do you travel? Different routes each trip? Would you travel from A to B to C to D then back to C then home to A? What you want is not simple if you say it slowly. I'm not saying it can't be done but you must be the judge of how complex it is to be. Gord Dibben Excel MVP On Fri, 18 Nov 2005 17:08:31 +0000 (UTC), "Nospam" wrote: I am trying to automate my weekly travel itinerary, which is an excel sheet. Ideally I would like to enter the destination into my itinerary, and then automatically have the mileage displayed in another column in the same sheet, and then have another sheet compiling my monthly mileage claim. I sort of realise this will need a sheet to be matched to, i.e one sheet showing the destination and mileage, my itinerary, and then the claim sheet. Reason is that mileage is claimed quarterly, and its a nightmare going over 13 itinerary's and matching the mileage Appreciate it anyone can point me in the direction where I can maybe work it out. Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|