I need an Excel expert

Completed Posted 4 years ago Paid on delivery
Completed Paid on delivery

I need an Excel expert set up a system for us to compare data from different [login to view URL] first file contains: order numbers, product SKU, quantity ordered and product price. The 2nd files has order number, amount paid and payment number. The code must find out which order was paid, amount of applied payment, find any possible amount discrepancy between product price and paid amount, label out the paid orders and list its payment number.

Excel Visual Basic

Project ID: #23438973

About the project

64 proposals Remote project Active 4 years ago

Awarded to:

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g More

$200 USD in 3 days
(923 Reviews)
9.4

64 freelancers are bidding on average $135 for this job

rahul62544

hello sir, hope you are doing great, i had read the description you provided about the project, i have the skills required for this job and i can do your work very effectively in very less time possible. hope to be awa More

$248 USD in 5 days
(905 Reviews)
8.7
ParisPallas

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application to retrieve data from another workbook and present it accord More

$200 USD in 5 days
(647 Reviews)
8.7
schoudhary1553

Hello, I can help you to create excel for comparison of data from different files I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already co More

$180 USD in 2 days
(555 Reviews)
8.4
Webxpert4u

I am ready to write codes in vba excel to compare data in 2 excel files. Can you share both sheets? Ready to discuss. Thank You

$235 USD in 4 days
(405 Reviews)
8.4
Khurramz

Hi Do you need the code writing status in front the orders (meeting the criteria)? please let me know via chat. thanks

$100 USD in 3 days
(406 Reviews)
7.9
trascenderglobal

Hello, this is Mauricio and I’m the Business Intelligence leader. With more than seven years of experience in Excel I can take this project and create the code to match the payments vs the order so you can keep track o More

$200 USD in 2 days
(170 Reviews)
7.9
Venkat2011sri

Hello, This is Venkat. I am very much interested in working with you on this project. I have 10 years of Experience in Data Entry, Web Scraping, PDF to Excel and other tasks. I look forward to work with you. I will g More

$200 USD in 2 days
(192 Reviews)
7.5
dgled

Hi, I’ve done many similar projects where the task was to clean, extract and compare data from one sheet to populate it in another sheet as a structured database. I do the projects by using algorithms and keyword. You More

$250 USD in 7 days
(94 Reviews)
7.5
RRconsultant

Greetings! I am a Specialist in excel and can help you with the requirements. Look forward to hear from you. Thanks, RRC

$200 USD in 7 days
(76 Reviews)
7.1
kolosibalint

Hi there, I can write an Excel script that allows you selecting the two source files with a file dialog. Once you selected the files, you press a button named Compare, and a procedure will perform the actions you desc More

$140 USD in 4 days
(130 Reviews)
7.1
atifdar

Hi there, Excel expert here Will use Vlookup function to populate data in file 1 against paid orders and payment number Will list the discrepancies (actual price vs. Payment) in different tab using Pivot tables techniq More

$49 USD in 1 day
(86 Reviews)
6.7
vsprybhanu

Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating and Exchanging Data in Multiple Sheets More

$45 USD in 3 days
(142 Reviews)
6.2
StormLion227

Hello. My name is Marko and I am an Engineering Graduate with an MBA degree. I am a full time freelancer and I will work hard on this till completion. An Expert Excel/VBA programmer on freelancer.com and I do not More

$155 USD in 0 days
(45 Reviews)
5.6
Ashisjena2015

Hi, I am a Chartered Accountant and advanced excel expert having more than 12 years experience in excel related project. I have done similar work on past. Please message me so that I will show you right now.

$150 USD in 2 days
(41 Reviews)
5.5
IgeS

Hi there, Do you need to have an automated order payment tracking in Excel? I can design you a template that will verify the payments made from the 2nd file and compare it to the 1st file, and produce an Excel report More

$120 USD in 3 days
(46 Reviews)
5.4
arash18k

Hi, I can develop a VBA program for you in an Excel file which has a "Update" button, When you press on Update button then Macro will open those two files, will list the paid orders and all other specified info will be More

$140 USD in 2 days
(13 Reviews)
4.9
mandeeps207

Hi there, I would like to complete this compare sheet for you. If you are interested in my proposal please reply asap. regards, Mandeep Singh

$30 USD in 1 day
(40 Reviews)
4.6
khanjzthanjzt

Hi I have read and understand the requirement, it’s very much doable and I’m experienced in making Macros, using VBA and mapping in excel. Allow me to complete this work without any error. Warmest Regards https://www.f More

$250 USD in 7 days
(11 Reviews)
4.5
PasionateAnalyst

I am an excel expert and I can help you and do your project in 5 days. Let’s discuss further details about it. I’ll be happy to help and work with you.

$222 USD in 5 days
(3 Reviews)
4.3
mmehdi786

Hi, I understand that you have several Excel files containing data that you want to compare. I can develop a VBA macro to help you make the comparison. The output could be shown on the form or Excel sheet depending on More

$200 USD in 6 days
(3 Reviews)
3.8