Build tool / makro to compare 2 excel files with each other + copy & sort data

i have a problem with some product data sheets in several different languages.

Actually i have lost the overview about which products are listed, which are not and for which ones i do not have translations yet.

I do not want to check that manually but i want a little tool for that. It should EAN Numbers of 2 files and make the sorting exactly the same as it is on the sourcefile.

Lets say we have 10 different EANs on the sourcefile, EAN 1 - 10

On the second file we only have EAN 1-5 and EAN 7-10.

What it should do then, is to copy the whole line with the found ean into a new sheet of the sourcefile at exactly the same line of the source EAN.

In the example mentioned here, it would mean that on the newly created sheet inside the sourcefile, there would be one line empty, the one for EAN 6

Files attached:

[login to view URL] is the sourcefile, With the first row being the EAN

[login to view URL] is the second file which has incomplete data and has to be copied into a new sheet of the sourcefile, each line at the exactly same line found in the source.

Please, since there are many automated bids on freelancer from people not even reading projectdescriptions first, I ask you to start your proposal with the words "Hi Steffen".

Everybody not starting with Hi Steffen will be sorted out immediately

Thank you very much.


Навыки: Excel, Visual Basic, PHP, Архитектура ПО, Python

Показать больше: excel macro copy paste data application, excel macro copy paste data, excel script copy cell data closed file, excel macro copy site data, excel macro copy paste data list websites, excel vba copy paste data, excel macro copy files, excel macro copy pdf data excel, Compare 2 files excel, excel vba copy filtered data to another sheet, excel vba copy formula down to last row, excel formula to sort data in ascending order, excel vba copy filtered data without headers, compare 2 excel files online, compare 2 excel sheets, excel formula to sort data in descending order, compare 2 excel columns in python, excel vba copy filtered data to another workbook, how to compare 2 xml files in excel, compare 2 excel files

О работодателе:
( 27 отзыв(-а, -ов) ) Bad Liebenzell, Germany

ID проекта: #29269812



Hi Steffen. I have very sharp Excel skills and i always like to do projects like this which require precision. I have already started inspecting the Excel files and willing to work on this. Thanks.

€60 EUR за 1 день
(101 отзывов(-а))

8 фрилансеров(-а) готовы выполнить эту работу в среднем за €143


(462 отзывов(-а))

Hi Steffen I can build a tool to resolve your problem waiting for discussion Thanks

€300 EUR за 2 дней(-я)
(217 отзывов(-а))
(191 отзывов(-а))

Hi Steffen You need to speed up your excel files analysis . I can provide you this tool to handle that.

€167 EUR за 5 дней(-я)
(62 отзывов(-а))

Hi Steffen, I am expert in Excel Formula, Advance Excel, Excel VBA, Excel Power Query, Excel Integration, Excel Macro, Excel Data Entry, Excel Data Scrapping, Excel Dashboard and API Integration, Excel financial model Больше

€30 EUR за 7 дней(-я)
(22 отзывов(-а))

Hello Sr. We are a team with 12 years experience in Ti Area. So we use a lot of technology's include some like Pyton, react , php, javascript, nodejs. . we can do anything you need. See my portafolio i have some mac Больше

€140 EUR за 7 дней(-я)
(9 отзывов(-а))

Hi Steffen I'm a senior Excel VBA expert. I have rich experience in Excel VBA and have developed a lot of Excel VBA projects before. If you want see my past Excel VBA projects, I can show you its. Please message me. Be Больше

€150 EUR за 3 дней(-я)
(2 отзывов(-а))