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
[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.
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.