Find Jobs
Hire Freelancers

I need a spreadsheet that references invoice data (job number, customer number, code and cost) from two different sheets and identifies discrepancies and missing data from either sheet

$30-250 USD

Completato
Pubblicato più di 6 anni fa

$30-250 USD

Pagato al completamento
I need a spreadsheet that calculates invoice data (job number work order number, customer number(hidden cell on one of the sheets), and cost) from two different sheets and identifies discrepancies and missing data from either sheet.
Rif. progetto: 15009009

Info sul progetto

62 proposte
Progetto a distanza
Attivo 7 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
Assegnato a:
Avatar dell'utente
I can implement a solution where you can download the 2 files for comparison into Excel and get a discrepancy and missing data report - all at the click of a button. Relevant Skills and Experience 18 years experience in using Excel as part of daily work life. In the process, implemented lot of automation. Over the last 12 MONTHS , spent at least 225 HOURS on automation in Excel every month. Proposed Milestones $50 USD - Automation to compare 2 Invoice details workbooks and generate discrepancy report
$45 USD in 1 giorno
5,0 (243 valutazioni)
7,0
7,0
62 freelance hanno fatto un'offerta media di $116 USD
Avatar dell'utente
Hello, My name is Jay and I am Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story). About Me - I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required in advance, please pay me once the job is 100% complete. Also I will provide you with a sample work before you may please consider awarding me the project. Thanks, Jay
$200 USD in 2 giorni
5,0 (850 valutazioni)
9,1
9,1
Avatar dell'utente
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I have the 5 years of experience with excellent knowledge. please give me a chance to work on your project Proposed Milestones $180 USD - payment after work completion
$180 USD in 3 giorni
4,9 (543 valutazioni)
8,4
8,4
Avatar dell'utente
Hi there - My name is Paris. I've read your brief and can see that you'd like to have an Excel spreadsheet to identify discrepancies and missing data. Relevant Skills and Experience I have 7 years experience in designing and developing Excel spreadsheets filled with formulas and VBA code. Proposed Milestones $150 USD - Deliver final and fully functional version tested and approved by you. When can we chat or talk? I am online from 3 to 11 pm (GMT+3).
$150 USD in 3 giorni
5,0 (478 valutazioni)
8,4
8,4
Avatar dell'utente
Hi, can you please provide more details about what you need. So we can after that discuss the logic of calculations and features you want to add. I can add formulas and/or macros. Thanks Expérience et Compétences appropriées Excel/VBA coder Étapes proposées $89 USD - m
$89 USD in 3 giorni
5,0 (331 valutazioni)
7,9
7,9
Avatar dell'utente
Hi: I can create a macro where you can import both the files (by click of a button) and then it will compare the data based on (job number, work order number, and customer number) Relevant Skills and Experience Please note that over 80% of my completed projects are related to Excel and Macro. Moreover, I have ~100% completion rate and ~5-star feedback on projects. Proposed Milestones $100 USD - Macro
$50 USD in 3 giorni
4,9 (177 valutazioni)
7,1
7,1
Avatar dell'utente
I can complete this project within a day for a least possible cost. I posses expertise in utilizing advance level tools of Excel for performing data analysis, Financial analysis, financial modelling etc. with years of experience.
$50 USD in 3 giorni
4,8 (172 valutazioni)
7,0
7,0
Avatar dell'utente
Hello I am an excel expert and would like to bid on the project posted by you. I have completed more than 100 projects in excel. Will send sample of my work, if requested. Rgds Rohit Pithisaria Relevant Skills and Experience Excel VBA Invoicing Accounting Bookkeeping Proposed Milestones $50 USD - Milestone 1
$50 USD in 1 giorno
4,9 (115 valutazioni)
6,5
6,5
Avatar dell'utente
I will create VBA Program (Macro) which search exact record from second file that will match with first file according to specified criteria. If found then appropriate action will be taken. Relevant Skills and Experience Experienced Data Analyst and Macro Developer. I have done mostly Excel VBA Programming to automate the process. Proposed Milestones $80 USD - initial $80 USD - second $90 USD - final
$250 USD in 3 giorni
4,8 (104 valutazioni)
5,8
5,8
Avatar dell'utente
Hello there! I'd be glad to serve you! I can start your project right now! Relevant Skills and Experience Excel spreadsheets automation, data processing from different sources, reporting, charting, and more Proposed Milestones $30 USD - Finalized tool Additional Services Offered $0.01 USD - All required support
$30 USD in 1 giorno
5,0 (32 valutazioni)
4,9
4,9
Avatar dell'utente
One of the tasks that can be done very perfectly by us. We are highly experienced Post Graduate Engineers, Doctors, IT, ITES, Software, Infrastructure Professionals, Web Designers and IT Architects. Relevant Skills and Experience One of the tasks that can be done very perfectly by us. We are highly experienced Post Graduate Engineers, Doctors, IT, ITES, Software, Infrastructure Professionals, Web Designers and IT Architects. Proposed Milestones $30 USD - milestones
$30 USD in 3 giorni
4,3 (13 valutazioni)
4,7
4,7
Avatar dell'utente
A proposal has not yet been provided
$165 USD in 1 giorno
5,0 (2 valutazioni)
2,7
2,7
Avatar dell'utente
I have extensive experience working on projects that require excel VBA skills. I'm keen on quality and delivering the project well advance in time. I'm sure you will be delighted with my work on your project.
$121 USD in 3 giorni
5,0 (2 valutazioni)
2,4
2,4
Avatar dell'utente
I propose to provide you a desktop application, where in the input from 2 excel files is considered and a resultant file (excel) is generated after all required modifications & chnages Relevant Skills and Experience .net, Excel are skills for this task . Lets be on chat to discuss in details Proposed Milestones $222 USD - as per discussion
$222 USD in 7 giorni
5,0 (1 valutazione)
0,9
0,9
Avatar dell'utente
I can do it immediately, like now. :) Relevant Skills and Experience .. Proposed Milestones $155 USD - .
$35 USD in 3 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
Hello,. hope you are doing great.!! My name is Anu, I have read your project description very carefully however it was not that long. :) Relevant Skills and Experience html css php data entry Proposed Milestones $155 USD - .. Lets discuss the project and start the work.
$155 USD in 3 giorni
0,0 (1 valutazione)
0,0
0,0
Avatar dell'utente
we are new on freelancer. but it already handles the project like this. Relevant Skills and Experience Dear Next Employer We will give you the best result by using my Past experience and excellent academic skills on your project. You can chat with me and let's get started, Thanks" Proposed Milestones $200 USD - BOOKKEEPING AND BANK RECONCILATION
$106 USD in 2 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
Advance excel user with relevant experience of more than seven years. Relevant Skills and Experience Excel Data Entry Software Development Proposed Milestones $100 USD - One time delivery - 100
$100 USD in 2 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
A proposal has not yet been provided
$110 USD in 2 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
A proposal has not yet been provided
$77 USD in 5 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
This project should take no more than, and likely less than, two days. We will need to discuss exactl requirements and desired output of the documents to come to a mutual understanding. Relevant Skills and Experience I am an administrative specialist. I work with documents similiar to these excel sheets on a daily basis. I would be able to create you a simple and user friendly document to use going forward. Proposed Milestones $83 USD - Project completion
$83 USD in 2 giorni
0,0 (0 valutazioni)
0,0
0,0

Info sul cliente

Bandiera: UNITED STATES
loves park, United States
5,0
3
Metodo di pagamento verificato
Membro dal ago 24, 2017

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.