Excel Expert Needed

$30-250 USD

Dokončeno

Zveřejněno

skoro před 5 roky

$30-250 USD

Zaplaceno při doručení

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

IČ projektu: 19767788

O projektu

17 nabídky

Vzdálený projekt

Aktivní před 5 roky

Chcete si vydělat nějaké peníze?

E-mailová adresa

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec

Získejte za svou práci zaplaceno

Načrtněte svůj návrh

Registrace a podávání nabídek je zdarma

Uděleno:

@datakillers

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 v 2 dnech

4,9

(700 recenze)

8,4

17 freelanceři nabízejí v průměru $121 USD za tuto práci

@P0L

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 v 3 dnech

5,0

(500 recenze)

8,0

@urielbaray

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 v 3 dnech

5,0

(62 recenze)

6,5

@SayTechSolution

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 v 7 dnech

4,7

(56 recenze)

5,7

@AMC1979

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 v 7 dnech

5,0

(6 recenze)

2,9

@shepherdrichard

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 v 7 dnech

5,0

(2 recenze)

2,7

@kohencpa

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 v 4 dnech

5,0

(2 recenze)

2,1

@abdulzaheerk7777

I will do this task efficiently and an a timely manner, I am expert data transfer, MS office specially MS excel

$85 USD v 3 dnech

0,0

(0 recenze)

0,0

@ahmdm1008

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 v 3 dnech

0,0

(0 recenze)

0,0

@freelancermb1991

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 v 2 dnech

0,0

(0 recenze)

0,0

@Rbb143

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 v 25 dnech

0,0

(0 recenze)

0,0

@Nabiharaza704

I'm familiar with all those skills that you have mentioned.

$100 USD v 5 dnech

0,0

(0 recenze)

0,0

@sauravthakkur

Looking forward to work with you

$155 USD v 3 dnech

0,0

(0 recenze)

0,0

@jinishpk

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 v 7 dnech