|
Hi, Very new to excel, and I need to create a spreadsheet for work. The sheet should have the worksheets at the bottom each be a business truck. The sheets themselves need to provide dates the vehicle was used, project numbers the vehicle was used in, how many Miles/hours were logged each day, and who drove/used the vehicle on those dates/projects.
They all need to correspond with each other; I need to see who used the truck on what day, for which project. It also needs to be sortable by each as well.
The purpose of this will be to quickly find information on each factor, for each truck. We currently have 8 trucks.
Any help would be greatly appreciated. I 'googled' my way here. If anyone can help, please e-mail me at trevor.chadwick!state.vt.us |