Hi, glad to be on the forum. Hopefully I can find a solution here.
I am working on a project in which I am creating a schedule for a truck washing station at my company. This is a excel spreadsheet that I will share with people at our other locations around the area. They will all be able to enter the name of the location and the truck number that is being washed to schedule a time.
Here is my dilemma. Each truck needs to be washed every two weeks. So, to keep each location on which truck is due for a wash I want to create a system that will display the last date a truck was washed.
For example, I would enter in location x and then truck number 12345. Once I enter it into the excel spreadsheet, is there a way to have the truck number populate in a list that says basically Truck 12345 - 06/12/2018 - Last wash
This may be not possible or too complex but any ideas would help.
Thanks!
Bookmarks