Completed

Write Excel Macro - Populate cells according to matches in other column

Column A: Strings in English

Column B: Translations of the string into Swedish in same row.

Column D: Some English strings

Column E: Please populate with the corresponding translation according to lists in A+B

Attached is a sample file. Coulmn E should be populated by Macro. If a string in D have no match in A then leave cell in E blank. If a string in D have several matches in A (ex 'Yes') then pls choose first one or any.

The columns can be put on different Excelsheets/split into several files if that helps.

The Macro should be able to search and run on large file with 13000 rows

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

See more: excel vba compare two columns different workbooks, excel lookup value in column and return value of another column, excel macro to compare two columns and write to a third, excel if two cells match then copy another cell, excel match two columns and output third, if two cells match then return another cell, how to compare two columns in two different excel sheets using macro, compare multiple columns in excel for matches, excel macro copying cell column, excel macro copy cell, excel macro move cell contents, write excel macro java instead, excel macro paste cell empty, excel macro paste cell internet explorer, excel macro use cell content, excel macro copy cell next cell, excel macro cut cell, excel macro copy cell content, excel macro change cell contents, excel macro copy cell contents

About the Employer:
( 60 reviews ) Lund, Sweden

Project ID: #16593238

Awarded to:

€36 EUR / hour
(217 Reviews)
7.3

15 freelancers are bidding on average €39/hour for this job

ksriniravi

Greetings! Being a full time freelancer working exclusively on Excel based projects, I work on developing macros every single day. I can write a macro for the required look up of Col D values in Col A. I have 18 More

€36 EUR / hour
(143 Reviews)
6.6
dpune

Hi, I have more than 14 years of Excel/VBA exp. Let us discuss more details so that I can estimate cost and time better. I have completed more than 310 projects. Please look at the feedback left by my em More

€36 EUR / hour
(205 Reviews)
6.6
polarjin2017

Hello? How are you? My name is GuangJun from china. I have good skills in this fields as you can see my reviews. So i think i can help you without any issue. Hope to work with you.

€40 EUR / hour
(53 Reviews)
5.9
€40 EUR / hour
(13 Reviews)
5.8
hardikshah83

Experienced programmer with more than 10 years of development experience here. I have handled production applications with various technologies like .NET, PHP, Classic ASP and many more using databases like MySQL, Mic More

€40 EUR / hour
(43 Reviews)
5.5
nwss1986

Hi, I can do the work for you. A simple loop will do the job, though it will take time and involves little bit complexity. With 13000 rows, i can do it for a flat rate of 50 Euros instead of hourly rate which might be More

€36 EUR / hour
(50 Reviews)
4.8
sajidkhan45

Hi, I went through your document and it looks pretty good. I would like to work on this [login to view URL] there are 13000 more entries like this? Please go through my profile so that you can be confident in my VBA skills H More

€36 EUR / hour
(14 Reviews)
4.1
€55 EUR / hour
(1 Review)
3.3
€40 EUR / hour
(3 Reviews)
2.2
shamimauap

£36 per hour /10 hours per week

€40 EUR / hour
(0 Reviews)
0.0
malirana

[login to view URL] to see your project.I have read the details.I have worked in excel before and the task you posted can be completed [login to view URL] forward . Thank You !!!

€36 EUR / hour
(0 Reviews)
0.0
mercynivah

A proposal has not yet been provided

€40 EUR / hour
(0 Reviews)
0.0
Indra001

I have completed your request now, I have the macro right now. I have created this in Access database so you can use more than 20 lacks data. Step 1 : Open the excel macro file which i created, And paste your table More

€40 EUR / hour
(0 Reviews)
0.0
Saffey

I have a very good experience in using excel, excel macros and functions. This includes using also VB and VC to automate Office files generations and editing.

€38 EUR / hour
(0 Reviews)
0.0