Help with an Excel question
I have a spreadsheet with 2 worksheets for rental of equipment, by the mile.
The equipment is not located at the office so we need to have the miles IN and OUT given to us by the renter.
Worksheet A has a pull-down list referencing the list of equipment in Column A on Worksheet B.
When the user selects a specific list of equipment on Worksheet A, the user will enter the miles OUT (starting miles) of the unit.
When the Miles IN is entered upon return, I would like that number to go to
Worksheet B, in column B,
That way, when a unit is rented again, I can see what the hours were when it was last rented, to ensure that the renter is giving me the correct Hours OUT.
Confused?
The equipment is not located at the office so we need to have the miles IN and OUT given to us by the renter.
Worksheet A has a pull-down list referencing the list of equipment in Column A on Worksheet B.
When the user selects a specific list of equipment on Worksheet A, the user will enter the miles OUT (starting miles) of the unit.
When the Miles IN is entered upon return, I would like that number to go to
Worksheet B, in column B,
That way, when a unit is rented again, I can see what the hours were when it was last rented, to ensure that the renter is giving me the correct Hours OUT.
Confused?