I have an excel spreadsheet that keeps a record of tool inventory on a fleet of trucks.
- 1 main data entry table
- A tab for each truck, showing the inventory per truck.
If the equipment changes, I would like to record the change in the main table - then have that change reflect on a truck inventory form specific to the truck. I am manually entering the data in 2 locations right now, and I don't have time to try to re-invent the spreadsheet I am keeping.
** I NEED TO BE ABLE TO EASILY ADD OR DELETE DATA **
Sometimes items change - we add or remove standardized equipment. I need to be able to add or remove equipment from the list. I keep inventory records of up to 25 trucks at 50 different geographical locations.
Each location will receive professional looking forms with a summary of inventory per truck.