Attached is an excel spreadsheet. It is a demo from [url removed, login to view] I need to 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.
Basically the function of the workshhet is an inventory system where the clerk counts up the present stock and enters the amount on hand and the spreadsheet calculates whats needs to be orderred based on minimum levels already set previosly.
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.
9.) Some pages will be deleted that are not required.
Please not that the demo attached is somebody elses work. I need a new spreadsheet basically with the same functionality but with some modifications...