Hello, I am going to present my situation with 2 excel sheets that I have, both of them with a lot of data. We will call “exported sheet” to the exported inventory list from my management software, and “right list” to the good one updated now by me about real situation of our stock. During some days, I have written all exact quantity of each product that I have in my real stock. Now, there are some problems: There are a lot of products in our warehouse which I don't know them well, so I don't know their reference codes. Due this, in the right sheet, there are 2 main columns. In "Referencia" column, I have written something that appears in any label of the product, and in "Descripción" column I have written what the product do, or small description that I can guess.
The exported sheet, contains a lot of lines with products that are repeated or maybe we don't use this product currently, so we have less different products that what our management software says. In the exported sheet, we can find the exact and right reference code of each product, and it has a more specific description, too.
I am trying to compare these 2 excel sheets. In one of them, I have the real situation of my stock (quantity), but reference codes are wrong (there is some code good), so it is very difficult for me to search one product from the right list in the exported sheet.
Reviewing the files, I have detected sometimes, reference codes of the right sheet, appear INSIDE the "Descripción" column of the exported sheet. However, the "Description" column of the exported sheet has more text than the reference code only.
Due to this, If I copy one reference code from the right sheet and I go and search for it in the exported sheet, it can finds the reference code (maybe on "Referencia" column or in "Descripción" column), so I can detect the line and correct stock quantity or maybe do another changes in description, etc.
The problem for me is that I have hundreds of different products, so it is crazy to do it one by one. Can you find a good and automatic way to select all reference codes from the right sheet, search them along some text of all cells of the exported sheet, and just select the lines? Then, I can copy all selected lines to a new sheet, make an alphabet order and then copy all data I need from the right sheet and paste on the new one.
44 pekerja bebas membida secara purata €27 untuk pekerjaan ini
Dear client I understand the situation you are in now with the file. I can make it easy for you. I would love to see both the files and then I recommend some solution in it. Looking forward to hear from you. Roy
Hello, I have seen your project now and I am interested in your project so if you want me then please message me then I will give you quality work. Thank you Best Regards Md Zaidur Rahman
Dear Client, I'm working as a professional freelancer. Please, look at my portfolio you may understand my working skill. Hope I can do your work at any cost. Thank you. Mahmud Reza Data Entry Specialist