Completed

Excel Macro built for 2 CSV files

This project was successfully completed by vbexcel for $50 USD in a day.

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
$30 - $250 USD
Completed In
1 day
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.

Thanks

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