In Progress

Build Mac Excel Spreadsheet Macro/VBA to Prioritize Stock Reorders

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.

Skills: Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps

See more: excel spreadsheet vba data entry form, can build front end excel spreadsheet, vba excel spreadsheet work, script excel spreadsheet macro read cells, copy paste excel spreadsheet macro, excel spreadsheet warehouse stock control, access vba open format excel spreadsheet, excel turn spreadsheet macro, excel 2007 macro vba update, example excel macro vba invoicexls forum, vba front end excel spreadsheet, protect excel spreadsheet macro, excel vba macro download yahoo stock data, build widget excel spreadsheet, excel create macro vba, excel spreadsheet macro permutations, mac excel spreadsheet, Build an excel spreadsheet from existing excel data, how to build an excel spreadsheet

About the Employer:
( 16 reviews ) Hampton, United States

Project ID: #17941279

Awarded to:


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)

2 freelancers are bidding on average $23 for this job


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

$30 USD in 3 days
(2 Reviews)