I need an Excel expert

Končano Objavljeno pred 4 letoma/leti Plačilo ob prevzemu
Končano Plačilo ob prevzemu

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

ID projekta: #23438973

Več o projektu

64 predlogov Oddaljen projekt Aktiven pred 4 letoma/leti

Dodeljeno:

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 Več

$200 USD v 3 dneh
(923 mnenj)
9.4

64 freelancerjev ponuja v povprečju za $135 na tem delu

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 Več

$248 USD v 5 dneh
(905 ocen)
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 Več

$200 USD v 5 dneh
(647 ocen)
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 Več

$180 USD v 2 dneh
(555 ocen)
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 v 4 dneh
(405 ocen)
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 v 3 dneh
(406 ocen)
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 Več

$200 USD v 2 dneh
(170 ocen)
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 Več

$200 USD v 2 dneh
(192 ocen)
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 Več

$250 USD v 7 dneh
(94 ocen)
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 v 7 dneh
(76 ocen)
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 Več

$140 USD v 4 dneh
(130 ocen)
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 Več

$49 USD v 1 dnevu
(86 ocen)
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 Več

$45 USD v 3 dneh
(142 ocen)
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 Več

$155 USD v 0 dneh
(45 ocen)
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 v 2 dneh
(41 ocen)
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 Več

$120 USD v 3 dneh
(46 ocen)
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 Več

$140 USD v 2 dneh
(13 ocen)
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 v 1 dnevu
(40 ocen)
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 Več

$250 USD v 7 dneh
(11 ocen)
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 v 5 dneh
(3 ocen)
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 Več

$200 USD v 6 dneh
(3 ocen)
3.8