Build Mac Excel Spreadsheet Macro/VBA to Prioritize Stock Reorders

进行中 已发布的 5 年前 货到付款
进行中 货到付款

Desired output is an Excel (Mac Version 14.7.7) spreadsheet which prioritizes restock from vendors by sales volume and/or profitability. Inputs are two data files exported from Quickbooks ("sales" and "stock") which are attached. Note that these data export files can be modified to some degree if required. Also, "sales" data file includes data for all inventory year-to-date while "stock" data file includes only those items that are out of stock (and not all inventory). Ideally, spreadsheet would open and show user a dialog box with button requesting data file import. Once data import is complete, dialog box would allow user to select a vendor from available vendors in the data set and then generate the report. Final report would sort items to be restocked prioritized by number of sales and profitability. Goal is to automate reordering and also to use data to reorder best products.

数据输入 数据处理 Excel Visual Basic Visual Basic的应用程式

项目ID: #17941279

关于项目

2个方案 远程项目 活跃的5 年前

授予:

mdshohidul95

Hi, I'm a Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps expert. I have read your project description carefully. I am interested to do your Job. I think I am the best person for your project.

$15 USD 在2天内
(0条评论)
0.0

有2名威客正在参与此工作的竞标,均价$23/小时

jalileng

being an engineer i believe i can do the job in better way.

$30 USD 在3天内
(2条评论)
2.2