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
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 Plus
21 freelance font une offre moyenne de $110 pour ce travail
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 Plus
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.
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 Plus
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 Plus
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 Plus
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 Plus
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 Plus
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 Plus
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.
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 Plus
I have done Microsoft office course and I have experience of 6 month in data entry and in love in the data entry
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 Plus
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 Plus
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
I will do this task efficiently and an a timely manner, I am expert data transfer, MS office specially MS excel
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 Plus
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 Plus