Suoritettu

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

Taidot: tiedonsyöttö, tietojenkäsittely, Excel, Visual Basic

Näytä lisää: 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

Tietoa työnantajasta:
( 0 arvostelua ) Florence, United States

Projektin tunnus: #19767788

Myönnetty käyttäjälle:

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 ski Lisää

$77 USD 2 päivässä
(206 Arvostelua)
6.9

21 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

Toperfection

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 Lisää

$100 USD 3 päivässä
(170 arvostelua)
7.9
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 3 päivässä
(292 arvostelua)
7.2
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 sam Lisää

$95 USD 3 päivässä
(29 arvostelua)
5.0
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 proj Lisää

$250 USD 7 päivässä
(48 arvostelua)
5.1
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 th Lisää

$150 USD 7 päivässä
(5 arvostelua)
2.8
emilianoreyes70

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 Lisää

$80 USD 3 päivässä
(1 arvostelu)
2.4
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 Lisää

$222 USD 4 päivässä
(2 arvostelua)
2.1
ironstar20311

Hi I am an experienced and skillful data entry and excel vba expert. I have rich experiences with data entry and processing and Excel VBA. I can finish your data entry project in time I promise high quality. Hope Lisää

$80 USD 3 päivässä
(2 arvostelua)
1.1
sauravthakkur

Looking forward to work with you

$155 USD 3 päivässä
(0 arvostelua)
0.0
marcosschualle

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 3 päivässä
(0 arvostelua)
0.0
$100 USD 7 päivässä
(0 arvostelua)
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 Lisää

$140 USD 7 päivässä
(0 arvostelua)
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 25 päivässä
(0 arvostelua)
0.0
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 Lisää

$140 USD 7 päivässä
(0 arvostelua)
0.0
Nabiharaza704

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

$100 USD 5 päivässä
(0 arvostelua)
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 Lisää

$80 USD 2 päivässä
(0 arvostelua)
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 3 päivässä
(0 arvostelua)
0.0
abdulzaheerk7777

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

$85 USD 3 päivässä
(0 arvostelua)
0.0
alexsun1222

Hi, Sir! i am a full Data entry expert with over 5 years on freelancer.com. ****In SPECIAL very familiar with Excel VBA.***** I have read your description and have interests in your project. I have rich experiences in Lisää

$30 USD 2 päivässä
(0 arvostelua)
0.0
hadiamirnejad

I'm Hadi Amirnejad and new in freelancer! So happy to cooperate with your company. note: If necessary, I can provide a team. Depending on the workload, I can decrease the bid amount. About me: I’m a master in Statistic Lisää

$30 USD 1 päivässä
(0 arvostelua)
0.0