Excel Expert Needed

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

Skills: Data Entry, Data Processing, Excel, Visual Basic

See more: php expert needed, joomla expert needed, web security expert needed, excel jobs from home, excel expert tutorial, weekend excel jobs, excel expert jobs, excel spreadsheet jobs from home, get paid to make excel spreadsheets, excel jobs from home part time, excel specialist job description, photoshop expert needed san jose, volusion expert needed, digg expert needed, linux expert needed, excel work needed, excel expert needed virtual assitant, query excel sheet excel expert needed, excel vba expert needed, excel maths expert needed

About the Employer:
( 3 reviews ) Florence, United States

Project ID: #19767788

Awarded to:


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 You can view my profile page for my ski More

$77 USD in 2 days
(341 Reviews)

18 freelancers are bidding on average $121 for this job


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
(384 Reviews)

Hello there, We have reviewed the requirements and are interested in offering our services. We have strong knowledge of platforms like LinkedIn,Hoover,Xing and other similar platforms which are useful in finding tar More

$100 USD in 3 days
(177 Reviews)

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 sam More

$95 USD in 3 days
(57 Reviews)

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 proj More

$250 USD in 7 days
(52 Reviews)

Hi! The data can beordered and filled as you explain, i see that the sku have 3 levels EX( [login to view URL]) so wil be separeted by each level an apply the image should apply. Im prepared to do this work. I will adbance t More

$80 USD in 3 days
(7 Reviews)

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 th More

$150 USD in 7 days
(6 Reviews)

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 More

$140 USD in 7 days
(2 Reviews)

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 More

$222 USD in 4 days
(2 Reviews)
$100 USD in 7 days
(0 Reviews)

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 More

$140 USD in 7 days
(0 Reviews)

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 Reviews)

Looking forward to work with you

$155 USD in 3 days
(0 Reviews)

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

$100 USD in 5 days
(0 Reviews)

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 More

$80 USD in 2 days
(0 Reviews)

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 Reviews)

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 Reviews)

I will provide an automated spreadsheet capable of handling future updates. This is my usual job at the university I work at, I truly hope you give me this opportunity.

$111 USD in 3 days
(0 Reviews)