Excel Macro built for 2 CSV files

  • Status Completed
  • Budget $30 - $250 USD
  • Total Bids 28

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.


Get free quotes for a project like this
Completed by:
Skills Required

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online