And then you can cross reference items like Oil change milage on the Vehicle Info table and last oil change from the Input Table to identify vehicles needing work. ![]() In that table you can have the VehicleID you want to use, make, model, year, VIN, etc (maybe Oil change milage, Oil change time, etc.)Īnd then you can also use Data Validation on the Input Table VehicleID column based on the Vehicle Info table to make sure you/they always use the right names for them. I would also recommend creating another table for Vehicle Info. You can also create a report tab that shows any vehicle needing service (based on certain criteria) You can then create a separate tab for reporting and have a pivot table or FILTER function and that report could be filtered based on Vehicle, Date range, type of service, or what ever you need Of course you will pick the fields that best fit what you will need but VehicleID will need to be unique (does NOT need to be VIN number, just unique for your system) That tab would be a basic table with something like Date, VehicleID, milage, action, notes ![]() SO, my recommendation is to create an all inclusive data entry tab. ![]() Another common mistake is trying to make the tab look just the way you want the report to print and then ask how do I enter data so it goes here and moves the existing data down or blah blah blah. For example, many people would set up a new tab for each vehicle and then later ask about how to do xyz across all vehicles. That said I commend you on asking before you set up the workbook because there are definitely some things to consider that could be beneficial down the road. In excel there are many ways to accomplish the same thing.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |