excelgeist

1 Create your own warehouse management program for 756 items Create worksheets

Playlist: https://www.youtube.com/watch?v=oE8rGiMhZoQ&list=PLcwMjDfa1J18dvR1Y1XMX97iPYdSBGAlN Page: https://excel.hpage.com/create Create your own warehouse management program for 756 items. Create worksheets. The description for this video lists all the labels that need to be entered. You can simply copy and paste them. This program only requires six worksheets. They are created as follows. Right-click the first sheet's tab and select "View Code". This sheet's property (Name) changes to "LLLRRR1". The next property on this sheet, Name, changes to "Mask". Right-click the second sheet's tab and select "View Code". This sheet's property (Name) changes to "LLLRRR2". The next property on this sheet, Name, changes to "Items". In the "Items" worksheet, row 1 contains: C1 – Sum: D1 – =SUM(D3:D758) E1 – =SUM(E3:E758) In the "Items" worksheet, row 2 contains the following headings: A2 - Items No., B2 - Description, C2 – Unit, D2 – Inventory, E2 - Total value the Inventory, F2 – Average Price. Right-click the third sheet's tab and select "View Code". This sheet's property (Name) changes to "LLLRRR3". The next property of this sheet, Name, will be changed to "Journal". In the "Journal" worksheet: merge and center all cells in the range A8:H8, and enter "Journal" in the merged range. Row 10 contains the following headings: A10 – ID No., B10 – Date, C10 – Document, D10 – Item No., E10 – Description, F10 – Unit, G10 – Quantity, H10 – Amount. Right-click the fourth sheet's tab and select "View Code". This sheet's property (Name) changes to "LLLRRR4". The next property of this sheet, Name, will be changed to "Removal certificate". Right-click the fifth sheet's tab and select "View Code". This sheet's property (Name) changes to "LLLRRR5". The next property of this sheet, Name, will be changed to "Items accounts". The following data is entered into the "Items accounts" worksheet: A1 – Removal certificate, B1 – Items number:, B2 – Description:, B3 – Unit:, B4 – Inventory:, B5 – Total value of inventory:, B6 – Average price:, C11 – ID No., D11 – Date, E11 – Document, F11 – Quantity, G11 – Amount. Right-click the sixth sheet's tab and select "View Code". This sheet's property (Name) changes to "LLLRRR6". These six worksheets were created. First worksheet: (Name) - LLLRRR1 Name - Mask Second worksheet: (Name) – LLLRRR2 Name – Items C1 - Sum: D1 – =SUM(D3:D758) E1 – =SUM(E3:E758) A2 – Items No. B2 - Description C2 – Unit D2 - Inventory E2 – Total value the Inventory F2 – Average Price Third worksheet: (Name) – LLLRRR3 Name – Journal Connect and center area A8:H8 - Journal A10 - ID No. B10 – Date C10 – Document D10 – Item No. E10 – Description F10 – Unit G10 – Quantity H10 – Amount Fourth worksheet: (Name) – LLLRRR4 Name – Removal certificate Fifth worksheet: (Name) – LLLRRR5 Name – Items accounts A1 - Removal certificate B1 – Items number: B2 – Description: B3 – Unit: B4 – Inventory: B5 – Total value of inventory: B6 – Average price: C11 – ID No. D11 – Date E11 – Document F11 – Quantity G11 – Amount Sixth worksheet: (Name) – LLLRRR6