Find Jobs
Hire Freelancers

Excel custom work

$2-8 USD / hour

Completed
Posted over 10 years ago

$2-8 USD / hour

Okay here is the problem... I have two spreadsheets that are very similar. I need to copy from spreadsheet named OMV cell data in T2 to spreadsheet named "ANALIZA" cell V6 data based on matching criteria in both spreadsheets. Data that I need to copy contains price of goods. Criteria from "ANALIZA" is : cells E3,F3,G3,L3,M3 and must mach cells7 columns that contains same data in spreadsheet "OMV" That means, I need to analyse price and quantity from file "OMV" for each individual item on list based on criteria from file "ANALIZA" and write to "ANALIZA" values to cells w6$ and x6$. Please help, I don't have a clue how to do this. I think that VLOOKUP function is the way to go. I need this to process big amount of data for my work. So I need formula that will help me to do this. Thanks
Project ID: 5240010

About the project

7 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
I am an ACCA , APA and Mcom finance You project has caught my attention as i know that this is my favorite topic and i am highly interested with due concern... I am fully competent in doing said assignment/job, as you see that most of my work is academic assignment/work.... i am a tutor since last 7 years and a freelancer hire me at fordable cost with best results, readily available for said task........ regards javed
$10 USD in 1 day
4.9 (32 reviews)
5.2
5.2
7 freelancers are bidding on average $8 USD/hour for this job
User Avatar
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.
$5 USD in 1 day
5.0 (74 reviews)
5.5
5.5
User Avatar
Hi, I'll be happy to help you with this for $50 as a fixed price -------------------------------------------------------------------------------------------------------------
$8 USD in 5 days
5.0 (27 reviews)
4.9
4.9
User Avatar
Hi, I will achieve the matching between two Excel sheets using VBA (Visual Basic for Applications). Using VBA a macro will be written to achieve this. Looking forward to discussing further on this with you. Brief intro about myself =================== Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word etc.. I have more than 10 years of experience to my credit. I have also worked on advanced VB features like making of ActiveX Exe, ActiveX dlls, OCX, Win32 API, multi-threading etc.. I fully understand on this highly competitive site how important it is to provide high quality work. My prime focus is 100% customer satisfaction. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks & Regards FineCoder
$10 USD in 10 days
4.9 (29 reviews)
4.8
4.8
User Avatar
A proposal has not yet been provided
$5 USD in 1 day
5.0 (3 reviews)
3.2
3.2
User Avatar
Edit ponude: Ma gdje su mi oči bile, pa već si okačio fajlove. Idem ih proučiti! Bok,Kruno! Ajde da se jednom dogodi i klijent s kojom mogu pričat bez spellcheckera :O) Po mom mišljenju najjednostavnije će biti da mi pošalješ fajlove, ja ih prebacim u Access i izanaliziram ti kaj god treba. Nažalost, ti znaš da mi ne možemo raditi za kikiriki ko Indijci, pa sam spustila cijenu na 10 dolara po satu, ali niže stvarno ne mogu. Međutim, mislim da komunikacija na materinjem jeziku vrijedi više od par dolara razlike u cijeni, ne? Uglavnom, nevolja s Excelom je to što on nije baza podataka već dvodimenzionalna rešetka za koju ti trebaju posebni aalati ako hoćeš postaviti relacije među podacima. No, da ne duljim. Access će nam pomoći u ovome, a možda ti se svidi pa odlučiš podatke trajno preseliti u pravu bazu koju bi ti rado napravila. Srdačan pozdrav i sretan ti Božić! :o) Klaudia
$11 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$5 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CROATIA
Slavonski Brod, Croatia
5.0
18
Payment method verified
Member since Dec 18, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.