Find Jobs
Hire Freelancers

Missing Invoices

$15-25 USD / hour

Closed
Posted almost 2 years ago

$15-25 USD / hour

We are trying to merge two sheets to where it finds the item on the list of sheet two on sheet one and brings over multiple columns and rows. We tried to do a power query but couldn't get that to work. I'm attaching the file for example. We need the data from sheet 1 to be pulled over into sheet 2 for only the items listed on sheet 2. Vlookup only brings over one row but each invoice has multiple rows and columns. Can you help with this? I have three more months for the merge but attached is just the one of the months.
Project ID: 34297036

About the project

92 proposals
Remote project
Active 2 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
92 freelancers are bidding on average $19 USD/hour for this job
User Avatar
Excel VBA expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platfrom give me a chance to show you the best i can do at your service.
$20 USD in 40 days
4.7 (151 reviews)
5.6
5.6
User Avatar
Hi There, I can do this right now with perfectly. Please message me to start your work now. Regard's Sobha
$15 USD in 40 days
5.0 (118 reviews)
5.3
5.3
User Avatar
Hi there, Do you need the processed output or a VBA-based application for this? Please message and let's discuss about your requirements. I'll be standing by to help. -Ige
$15 USD in 4 days
5.0 (46 reviews)
5.4
5.4
User Avatar
Hi sir! I understood your project requirements perfectly and ready to start right now. Just need to discuss some details on chat. I am offering you an affordable price, however, it may be negotiable after discussing if you want. Let's connect over chat for further details. Thanks (I also offers my support to my clients for editing or changing in project (if required by you) “Without Any Cost” even after completion of project)
$15 USD in 40 days
4.9 (38 reviews)
5.3
5.3
User Avatar
hello I can do this project very quick. I think is possible to do all 3 month data together I can do it using Excel VBA . It's very powerful app for like this cases I'm working in Distribution company and I'm doing like this things very frequently I'm working on big reports with more then 1 000 000 rows. So I have very good experience I have 15+ year experience of Excel, Excel VBA, Python and 100% feedback So, you can trust to me. Result will be excellent Best Regard
$15 USD in 40 days
5.0 (32 reviews)
4.5
4.5
User Avatar
Hi sir there are total 36139 records after copy. would you like to get this job done within 10 minutes........ regards
$20 USD in 1 day
4.9 (7 reviews)
4.5
4.5
User Avatar
Hi I've read the project description carefully. I'm an expert in Excel VBA. It would be a great pleasure for me to have the opportunity working with you. ✓ Looking forward to hearing more about your project via chat. plz check my profile in here: https://www.freelancer.com/u/anenkovakateryna. Best regards!
$15 USD in 40 days
4.6 (5 reviews)
3.8
3.8
User Avatar
Good Morning. I would love to take on this project. I do loads of data entry for my buisness. I am sure I can help get your issues resolved in a timely manner. Thank you for considering me.
$23 USD in 20 days
5.0 (1 review)
3.6
3.6
User Avatar
I can easily do this with python pandas. Let me know.I will charge one time 30 USD. I am really interested in this job. I am currently working as a Senior Data Engineer in an IT Company. I'm offering the best quality and highest performance at a price we are both comfortable with. I can complete your project on time and your will experience great satisfaction with me. I'm well versed in Python,Unix Scripting, Excel VBA etc . I have rich experience in Word, PDF, Data Processing, Data Entry, Web Scraping. For more information about me, please refer to my portfolios. I'm ready to discuss your project and start immediately. Looking forward to hearing you back and discussing all details Thank you! Ashish Dudeja
$20 USD in 40 days
5.0 (1 review)
2.9
2.9
User Avatar
Hi, I checked your requirement, This is awsome work for me because i have Experience in below technical work. Power Bi Desktop & Services With DAX, Power Editor, Excel VBA, Power Query, Power Pivot, Advance Excel, Excel Dashboard dynamically with VBA Codes. Knowledge About Json file, SQL, MS Access with VBA etc. For More Details Check my Portfolio's Sample Work. With Best Regards, Data Analyst/Power bi Specilist
$20 USD in 8 days
5.0 (3 reviews)
2.5
2.5
User Avatar
Ready to Write a script that will pull data from sheet1 for Ref_Number(s) listed on Sheet2 Only as required
$15 USD in 40 days
5.0 (2 reviews)
2.3
2.3
User Avatar
I read your requirement carefully and i am able to do this project successfully. I can do more then your requirement, if you need extra care of yourself then please give me touch, I will 24 hours online for your help. Please give me a chance. I assure you i will give my 100% and satisfied you. Looking forward to hear from you. Thank you. Your Name
$15 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a graduate on Computer Science with the highest CGPA. Also, I have several good records in this field as I have been working in this field for about 5 long years. I am an expertise on Data entry and excel, also have proficiency in MS office, Google analytics and QuickBooks and 10-Key KPH typing speed with zero errors. Working with me will surely bring you many good as I am very creative and persuasive in nature. Also, I can handle things diplomatically with full professionalism. With full guarantee, I can assure you the deliverables you have asked for in the job description. So, pick me up if you think I am worth the job. Thank you.
$20 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Iam days entry operator. I have 2 year of experience. Iam capable to work in data entry Ms Excel and PDF.
$18 USD in 6 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I read your requirement carefully and i am able to do this project successfully. I can do more then your requirement, if you need extra care of yourself then please give me touch, I will 24 hours online for your help. Please give me a chance. I assure you i will give my 100% and satisfied you. Looking forward to hear from you. Thank you. Your Name
$20 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, Sure i have seen the sample file ,Will be able to complete it, I have experience for past 6 years Kind regards Richard daniel
$20 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i will do very well . i am fast typing . i will do your job very well We are trying to merge two sheets to where it finds the item on the list of sheet two on sheet one and brings over multiple columns and rows. We tried to do a power query but couldn't get that to work.
$20 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have 8 years of experience in data preparation and analysis. and have solution for your specific requirements. I would be honored to work for your specific requirements. Regards Omprakash
$20 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Cause i have a great experience on data entry jobs for almost 3 years and more than that i can also convert any document to pdf or docx etc.
$20 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm very much interested on your project to work on it. Please let me know if you have any concerns to proceed further. Thank you
$20 USD in 40 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Dallas, United States
0.0
0
Member since Aug 5, 2022

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.