Thank you for the quick reply!
Basically, I need three different sheets (plus the dashboard).
- Current Inventory Sheet
- Columns: SKU, Manufacturer, Item name, Current quantity in stock, Reorder point, MSRP, Wholesale price
- Check In Sheet
- Columns: Check in date, SKU, Manufacturer, Item name, Quantity adding, Sign off/Initials
- Check Out Sheet
- Columns: Check out date, SKU, Manufacturer, Item name, Quantity removing, Sign off/Initials, What project it’s for
Our team works with first responders to upfit their vehicles and we need a detailed but simple inventory management system to keep track of everything. Thank you for your help!