Excel Macro built for 2 CSV files
- Status Completed
- Budget $30 - $250 USD
- Total Bids 28
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.
ThanksGet free quotes for a project like this
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online