Đang Thực Hiện

136293 Excel Spreadsheet modification

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.

Kĩ năng: Bất kì công việc gì, Visual Basic

Xem nhiều hơn: visual basic cost, Account clerk , spreadsheet 2, excel spreadsheet, Excel report, excel inventory, excel function, excel 7, create spreadsheet, create excel worksheet, clerk, ave, account spreadsheet, spreadsheet columns, excel match count, excel count, excel column update, modification pending order, inventory value, excel order system, create workbook, create report excel spreadsheet, create inventory excel, inventory quantity update excel, remain quantity

Về Bên Thuê:
( 3 nhận xét )

ID dự án: #1882465