In Progress

Excel Macro built for 2 CSV files

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: Data Entry, Excel, Mac OS

See more: excel macro create csv file, excel macro compare csv, what is macro in excel, excel-to-csv, Excel to CSV, Excel Formulas, csv product import, excel macro csv, compare rows excel, import data macro excel, csv column format, files missing, excel compare columns data, missing columns data, project macro, excel 2013 macro, point excel, excel compare names, excel file data points, macro import csv, import data entry excel, turnover excel, excel create macro, create excel formulas, create macro project

About the Employer:
( 38 reviews ) St. Petersburg, United States

Project ID: #4280449

Awarded to:

vbexcel

Excel pro with over ten years of experience.

$50 USD in 1 day
(25 Reviews)
5.3

27 freelancers are bidding on average $57 for this job

sonarkaushik

Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

$58 USD in 2 days
(55 Reviews)
5.6
nagybatonyi

Such jobs are my daily practice. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering the usual Open file More

$50 USD in 1 day
(38 Reviews)
5.3
mrbrave

I have great experience in developing macros for handline CSV file in Excel..See message box for demo.

$60 USD in 1 day
(59 Reviews)
5.2
cheapexcell

Ready to start

$45 USD in 1 day
(34 Reviews)
5.1
Nhcuong

Hi, I can do it. I'm a programmer for year and very familiar with Excel vba for automation tasks like this. What is your ms office version? I can write a macro for you simply run and select the two input file. The More

$50 USD in 10 days
(20 Reviews)
4.9
slavisatosic

Hello, I am offering to make this macro by tomorrow. Please, see PM for details.

$50 USD in 1 day
(32 Reviews)
4.7
pierreho

Hello tylerbook, I am a supply chain and excel/VBA specialist. It should not be a problem. Best regards

$50 USD in 3 days
(23 Reviews)
4.7
Engineer85

Hi I am an Excel professional and can do this job for you. Thanks

$30 USD in 1 day
(14 Reviews)
4.5
jal540

I have done many custom Excel projects and have excellent ratings.

$50 USD in 7 days
(11 Reviews)
4.2
JackBradford

Hi, I can do this using VBA and make it so it will be automated for the next time you need to process the same type of csv files. I'm sure I can do this in 1 day, but I put 2 just in case I get hit with a curve b More

$100 USD in 2 days
(7 Reviews)
3.5
vikashgadia

we are excel vba expert

$50 USD in 1 day
(13 Reviews)
3.5
youngtiger

Sir, Please check PM

$150 USD in 2 days
(6 Reviews)
3.3
seaanddream

Hi, it is my pleasure to help you with your project. I read the description, the job exactly fits my skills. KR,

$49 USD in 3 days
(5 Reviews)
2.8
buyaspreadsheet

Why pick me? I have over 7 years experience of designing and implementing advanced Microsoft Excel and VBA based solutions and I do not anticipate any issues in completing this project. My freelancer feedback to date h More

$60 USD in 2 days
(5 Reviews)
2.7
epdailo

I can help you with this project.

$30 USD in 7 days
(2 Reviews)
2.2
minhchauprp

I have done some job like that and i can complete this job in a short time and exactly. Send me your sample, i will show you what i can do. Thanks!

$30 USD in 1 day
(1 Review)
2.1
srisubra

Hey Tyler, I've 15 years experience in Excel and 10 years of it in VBA Macros in Excel. I've recently completed one Excel VBA project in this Freelancer in 2 days. You can check my skills in my portfolio page. Lookin More

$150 USD in 2 days
(2 Reviews)
1.4
codemannz

I have years of experience with macros.

$30 USD in 1 day
(1 Review)
1.0
accurateG

Hi,I can do [url removed, login to view] check your PMB.

$60 USD in 2 days
(11 Reviews)
0.2
RMFlanagan

I understand what is needed and exceed qualifications needed. I just joined this website looking for some extra cash. I am currently employed and have a Masters of Information Systems degree. I work with MS Excel and M More

$50 USD in 2 days
(0 Reviews)
0.0