Build Mac Excel Spreadsheet Macro/VBA to Prioritize Stock Reorders

In Progress Posted 5 years ago Paid on delivery
In Progress Paid on delivery

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.

Data Entry Data Processing Excel Visual Basic Visual Basic for Apps

Project ID: #17941279

About the project

2 proposals Remote project Active 5 years ago

Awarded to:

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 in 2 days
(0 Reviews)
0.0

2 freelancers are bidding on average $23 for this job

jalileng

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

$30 USD in 3 days
(2 Reviews)
2.2