Find Jobs
Hire Freelancers

Excel Expert Needed

$30-250 USD

Imekamilika
Imechapishwa almost 5 years ago

$30-250 USD

Kulipwa wakati wa kufikishwa
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
Kitambulisho cha mradi: 19767788

Kuhusu mradi

17 mapendekezo
Mradi wa mbali
Inatumika 5 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
Imetolewa kwa:
Picha ya Mtumiaji
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 ndani ya siku 2
4.9 (700 hakiki)
8.4
8.4
17 wafanyakazi huru wana zabuni kwa wastani $121 USD kwa kazi hii
Picha ya Mtumiaji
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 ndani ya siku 3
5.0 (500 hakiki)
8.0
8.0
Picha ya Mtumiaji
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 ndani ya siku 3
5.0 (62 hakiki)
6.5
6.5
Picha ya Mtumiaji
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 ndani ya siku 7
4.7 (56 hakiki)
5.7
5.7
Picha ya Mtumiaji
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 ndani ya siku 7
5.0 (6 hakiki)
2.9
2.9
Picha ya Mtumiaji
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 ndani ya siku 7
5.0 (2 hakiki)
2.7
2.7
Picha ya Mtumiaji
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 ndani ya siku 4
5.0 (2 hakiki)
2.1
2.1
Picha ya Mtumiaji
I will do this task efficiently and an a timely manner, I am expert data transfer, MS office specially MS excel
$85 USD ndani ya siku 3
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
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 ndani ya siku 3
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
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 ndani ya siku 2
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
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 ndani ya siku 25
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
I'm familiar with all those skills that you have mentioned.
$100 USD ndani ya siku 5
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Looking forward to work with you
$155 USD ndani ya siku 3
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
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 ndani ya siku 7
0.0 (0 hakiki)
0.0
0.0

Kuhusu mteja

Bedera ya UNITED STATES
Florence, United States
5.0
3
Njia ya malipo imethibitishwa
Mwanachama tangu Mei 24, 2019

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.