Excel Macro built for 2 CSV files

IN PROGRESS
Bids
28
Avg Bid (USD)
$61
Project Budget (USD)
$30 - $250

Project Description:
We have two csv files that we want to import into excel to have formulas applied to ::: .

The CSVs we use have static number of columns, and static column names, if that helps. We want formulas applied to compare quantity sold (which is on one csv) against current re-order points (on the other csv) and create a result in the format of second csv. Here's a crude breakdown of what the end result should be:

reorder point = quantity sold/2 + 20%
reorder amount = quantity sold

This is based on a given time frame of product turnover. We also have turnover percentages on the first csv which may be helpful to avoid missing a valid re-order point.

The csv files will vary in rows.

I will provide sample CSVs file once the project has been awarded.

Thanks

Skills required:
Data Entry, Excel, Mac OS
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 58
in 2 days
Hire nagybatonyi
$ 50
in 1 days
$ 50
in 1 days
Hire mrbrave
$ 60
in 1 days
Hire cheapexcell
$ 45
in 1 days
$ 50
in 10 days
Hire slavisatosic
$ 50
in 1 days
$ 50
in 3 days
Hire Engineer85
$ 30
in 1 days
$ 50
in 7 days