Find Jobs
Hire Freelancers

Excel Expert Needed

$30-250 USD

Completed
Posted almost 5 years ago

$30-250 USD

Paid on delivery
I am working on a project where I need to upload products to my website. To accomplish this, I need a .CVS file with specific information in each row and column. The manufacturer has supplied the information, but it is not in the same format needed for a successful upload. There are over 80,000 rows of data that need to be completed using an automated process and I do not know how to do it and need help with a formula to automatically fill the cells with the correct data. I am not an excel expert so I do no know if this can be done, but here is what I need. I have several filled columns with data in them and that data needs to be used to fill two blank columns using an automated process. The ImageName in Column H needs to autofill into the appropriate cells in Column F & G as shown in the attached example. As you can see in the example, F2-F26 is filled in red using the data from H2 Image Name because the image name in H1 matched the VendorProductCode in B2-B26. Example H1 [login to view URL] matches B1-B26 029HBM so it is used to fill the cells F2-F26. Also, you can see that ViewSrc1 G2-G7 is filled in green using the data from H3 Image Name because the image name matches the VendorProductCode+ColorName in C2-C7. Example H2 [login to view URL] matches C2-C7 [login to view URL] so it is used to fill the cells G2-G7. See attached example
Project ID: 19767788

About the project

17 proposals
Remote project
Active 5 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
Hi I am an expert with great skills of data processing, Microsoft Excel, data entry and data management. I have successfully completed lot of tasks here means at freelancer.com. You can view my profile page for my skills, review and feedback of my client I hopefully said that you will be satisfied to award me this job and I promise that I will deliver you a great quality output in timely manners. Your work will be delivered well in advance with seamless communication & timely response until project is completed. As well as for any alternation and query we are available 24 x7. Looking forward for nice start to great future business relations
$77 USD in 2 days
4.9 (700 reviews)
8.4
8.4
17 freelancers are bidding on average $121 USD for this job
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$100 USD in 3 days
5.0 (500 reviews)
8.0
8.0
User Avatar
Hi! Thank you for taking the time to read my proposal, My name is Uriel Baray I am a VBA Excel Expert with several years of experience on the field, if you are so kind to take a look to my portfolio, I have some samples for you there. Please send me a message so we can discuss further details of your project
$95 USD in 3 days
5.0 (62 reviews)
6.5
6.5
User Avatar
Hello, Hope you are having a good day! I have read your project brief and its perfect fit for my skill sets. I have years of experience in eCommerce Industry and Content Management System. I am sending my similar project work to welcome you and asking an opportunity to work with you. https://www.freelancer.com/projects/php/Create-Products-CSV-file-for I'm much interested to work on this project and willing to start it immediately, would love to speak with you to discuss further. Kind Regards Subhash
$250 USD in 7 days
4.7 (56 reviews)
5.7
5.7
User Avatar
Hello, My name is Albert and I have a lot of experience in Excel (including formulas, macros and VBA). I have been an Excel user for many years, I have taken courses and I have learned in a self-taught way all that the courses did not teach me. In addition, I am passionate about programming (Java, C ++, etc) and, of course, I have learned and used VBA many times to adapt Excel files (or Acces) for everything I needed when Excel itself can not do it. In VBA I have done everything: advanced calculation functions, functions to customize the display format depending on each case, simple automated copy and paste functions, etc. I can not specify more about this project because I do not have more information, what I can assure you is that I can do it satisfactorily. Before saying goodbye I wanted to thank you for giving me the opportunity to bid and I wanted to invite you to visit my profile or to contact me. I look forward to any clarification. Thank you very much and best regards.
$150 USD in 7 days
5.0 (6 reviews)
2.9
2.9
User Avatar
Author of Access 2010 VBA Macro Programming (ISBN 0071738576 published by McGraw-Hill) Author of Excel 2007 VBA Macro Programming (ISBN 0071627006 published by McGraw-Hill) Author of Excel VBA Macro Programming (ISBN 0072231440 published by McGraw-Hill) Fellow of the Association of Chartered Certified Accountants Extensive experience of developing MI reporting systems / databases/ dashboards using VBA / RAD for major companies such as Santander, Nationwide Building Society, and Zurich Insurance Expert on Microsoft Office, VBA, Oracle and Microsoft SQL Server Available for short / long term consultancy Specialties: Customer facing designing and developing software applications from scratch. Using RAD techniques to develop to extremely tight timescales
$140 USD in 7 days
5.0 (2 reviews)
2.7
2.7
User Avatar
Hello, I am an accountant with advance excel skills. I can convert pdf files and format them to your liking. I write complex formulas, pivot tables and Vlookups as well as VBA Macros. Please contact me and we will get started.
$222 USD in 4 days
5.0 (2 reviews)
2.1
2.1
User Avatar
I will do this task efficiently and an a timely manner, I am expert data transfer, MS office specially MS excel
$85 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, In my opinion i am the best candidate for your job because in my real life i am working as a data entry of Microsoft office so let our job done quickly with the cheapest price
$83 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am going to use several excel techniques to match the columns. I have seen the excel file that you have provided. I am an advanced excel user. If you say so, I can provide the sample file to show you how I am going to finish it. I counter such data in my daily routine as I am professional accountant. I am new to this site that is the reason I am charging such a low rate.
$80 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have done Microsoft office course and I have experience of 6 month in data entry and in love in the data entry
$106 USD in 25 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm familiar with all those skills that you have mentioned.
$100 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Looking forward to work with you
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Having 6 years of experience in Designing, Developing and Customization of Windows Applications Experienced in working with VB 6.0,VB.Net,C#, Microsoft Dynamic Navision 2013 Technically strong SQL 2008 R2,VB 6.0 Good analytical, problem solving and communication skills Self-motivated and quick learner of new concepts and technologies Reporting Service SSRS and Crystal Reports Microsoft Dynamic Navision 2013 Implementation, troubleshooting and Report designing
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Florence, United States
5.0
3
Payment method verified
Member since May 24, 2019

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.