Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel worksheet
I have records of deliveries made to customers. Column headings include
depot (a 4 digit id number), customer number, customer name and address. Each day I manually type in the time taken and distance travelled for each delivery. These values are preset and do not change. Most of the deliveries are made from the same depot to the same customer, but occasionally when product is unavailable the depot of origin will change. I would like a method of checking customer number and depot of origin and inserting values in the time and distance columns. I would appreciate any suggestions. -- lyn |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Change position of move or copy worksheet option in Excel | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
how do I name ranges in an Excel worksheet | Excel Worksheet Functions |