Automobile Spare Parts List In Excel -

' Add new spare part Sub AddNewSparePart() ' Get part number, description, quantity, unit price, supplier, and category from user Dim partNumber As String Dim partDescription As String Dim quantity As Integer Dim unitPrice As Double Dim supplier As String Dim category As String

A great inventory list is organized logically. You wouldn't put brake pads next to engine oil. Below is a comprehensive, categorized list of spare parts you should include in your Excel sheet. automobile spare parts list in excel

Contact info for the vendor who provides the part. ' Add new spare part Sub AddNewSparePart() '

' Create template Sub CreateTemplate() ' Create worksheets Set wsSpareParts = ThisWorkbook.Worksheets.Add(After:=ThisWorkbook.Worksheets(ThisWorkbook.Worksheets.Count)) wsSpareParts.Name = "Spare Parts List" automobile spare parts list in excel