Attached is an excel spreadsheet. I need to modify or create a new spreadsheet that basiclly has the same funtions. Many of the columns will bbe removed, mostly that have cost information. The inventory out workbook needs to be changed to account for present inventory.
asically the function of the workshhet is an inventory system.
1.) Item Summary worksheet will remain.
Remove columns Cost Each,On Hand Value, Category
2.)Inventory In worksheet will remain as is
3.)Inventory Out will be changed to be Current Inventory count. It should match column in Item Summary and not be date driven. When an inventory count is taken, clerk will enter number and it will update Item Summay Worksheet on habd quantity amount.
4.) Item Setup remains basically the same. It should update the Item Summary and new Current Inventory workbooks. columns Cost Each, Category, Date, Comment need to be removed.
5.) Order report needs to be created. without column extended cost.
6.) Also need a function to delete an item
7.) Needs to be sorted by vendor
8.) Needs to be able to ave more than 30 rows.