Käynnissä

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

Taidot: tiedonsyöttö, Excel, Mac OS

Näytä lisää: excel macro compare 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, turnover data excel, import excel file project, macro data entry, file excel compare

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

Projektin tunnus: #4280449

Myönnetty käyttäjälle:

vbexcel

Excel pro with over ten years of experience.

50 $ USD 1 päivässä
(25 arvostelua)
5.3

27 freelanceria on tarjonnut keskimäärin 57 $ tähän työhön

sonarkaushik

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

58 $ USD 2 päivässä
(55 arvostelua)
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 Lisää

50 $ USD 1 päivässä
(38 arvostelua)
5.3
mrbrave

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

60 $ USD 1 päivässä
(59 arvostelua)
5.2
cheapexcell

Ready to start

45 $ USD 1 päivässä
(34 arvostelua)
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 Lisää

50 $ USD 10 päivässä
(20 arvostelua)
4.9
slavisatosic

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

50 $ USD 1 päivässä
(32 arvostelua)
4.7
pierreho

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

50 $ USD 3 päivässä
(23 arvostelua)
4.7
Engineer85

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

30 $ USD 1 päivässä
(14 arvostelua)
4.5
jal540

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

50 $ USD 7 päivässä
(11 arvostelua)
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 Lisää

100 $ USD 2 päivässä
(7 arvostelua)
3.5
vikashgadia

we are excel vba expert

50 $ USD 1 päivässä
(13 arvostelua)
3.5
youngtiger

Sir, Please check PM

150 $ USD 2 päivässä
(6 arvostelua)
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 3 päivässä
(5 arvostelua)
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 Lisää

60 $ USD 2 päivässä
(5 arvostelua)
2.7
epdailo

I can help you with this project.

30 $ USD 7 päivässä
(2 arvostelua)
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 1 päivässä
(1 arvostelu)
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 Lisää

150 $ USD 2 päivässä
(2 arvostelua)
1.4
codemannz

I have years of experience with macros.

30 $ USD 1 päivässä
(1 arvostelu)
1.0
accurateG

Hi,I can do it.Please check your PMB.

60 $ USD 2 päivässä
(11 arvostelua)
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 Lisää

50 $ USD 2 päivässä
(0 arvostelua)
0.0