I need an Excel expert

Slutfört Publicerat 4 år sedan Betalades vid leverans
Slutfört Betalades vid leverans

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

Projekt-id: #23438973

About the project

64 offerter Distansprojekt Aktivt 4 år sedan

Tilldelades:

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 Mer

$200 USD inom 3 dagar
(923 omdömen)
9.4

64 frilansare har lagt bud på i genomsnitt $135 för det här jobbet

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 Mer

$248 USD inom 5 dagar
(905 omdömen)
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 Mer

$200 USD inom 5 dagar
(647 omdömen)
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 Mer

$180 USD inom 2 dagar
(555 omdömen)
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 inom 4 dagar
(405 omdömen)
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 inom 3 dagar
(406 omdömen)
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 Mer

$200 USD inom 2 dagar
(170 omdömen)
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 Mer

$200 USD inom 2 dagar
(192 omdömen)
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 Mer

$250 USD inom 7 dagar
(94 omdömen)
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 inom 7 dagar
(76 omdömen)
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 Mer

$140 USD inom 4 dagar
(130 omdömen)
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 Mer

$49 USD inom 1 dag
(86 omdömen)
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 Mer

$45 USD inom 3 dagar
(142 omdömen)
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 Mer

$155 USD inom 0 dagar
(45 omdömen)
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 inom 2 dagar
(41 omdömen)
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 Mer

$120 USD inom 3 dagar
(46 omdömen)
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 Mer

$140 USD inom 2 dagar
(13 omdömen)
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 inom 1 dag
(40 omdömen)
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 Mer

$250 USD inom 7 dagar
(11 omdömen)
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 inom 5 dagar
(3 omdömen)
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 Mer

$200 USD inom 6 dagar
(3 omdömen)
3.8