Build Mac Excel Spreadsheet Macro/VBA to Prioritize Stock Reorders

Pågående Publicerat 5 år sedan Betalades vid leverans
Pågående Betalades vid leverans

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.

Datainmatning Databehandling Excel Visual Basic Visual Basics för apps

Projekt-id: #17941279

About the project

2 offerter Distansprojekt Aktivt 5 år sedan

Tilldelades:

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 inom 2 dagar
(0 omdömen)
0.0

2 frilansare har lagt bud på i genomsnitt $23 för det här jobbet

jalileng

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

$30 USD inom 3 dagar
(2 omdömen)
2.2