Ditutup

Data modification and comparing in Excell sheets -- 2

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.

Kemahiran: Pemasukan Data, Pemprosesan Data, Excel, Kejuruteraan Perisian, Visual Basic

Lihat lagi: data mining websites excell, data entry columns excell, javascript data modification, net work excell sheets, comparing excel sheets, convert data dat file excell file, combining excell sheets, code comparing excel sheets, comparing excel sheets net, data entry forms excell, extract data mysql database excell sheet, database data modification, data modification excel, data base data entry pdf excell, data base pdf excell, microsoft access data modification, data modification, create program for extract product data from particular online shop -- 2, create program for extract product data from particular online shop 2

Tentang Majikan:
( 9 ulasan ) Villarreal, Spain

ID Projek: #21594990

44 pekerja bebas membida secara purata €27 untuk pekerjaan ini

fattahaabdul

I can modify and compare data for you. I can start now and deliver asap. I have 8+ years of experience in data entry. I assure you that I will give 100% quality work. Let us discuss and proceed further in chat. I am Lagi

€30 EUR dalam sehari
(71 Ulasan)
7.5
zebracaro

I can do it for you quickly and exactly .Please contact me for saving your time and your money .

€30 EUR dalam sehari
(124 Ulasan)
7.1
elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the proje Lagi

€50 EUR dalam 3 hari
(236 Ulasan)
6.9
TonmoyRoy111

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

€50 EUR dalam 2 hari
(334 Ulasan)
6.8
MohsanEijaz

Hi there, I am excel and vba expert, I can automate this manual process. All process will be automate by using vba coding. Malik

€55 EUR dalam 7 hari
(89 Ulasan)
6.3
sonarkaushik

Sir,      I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards

€28 EUR dalam 2 hari
(112 Ulasan)
6.3
choprac

Hello, Hope you are doing good, I am Charu Chopra from Dallas, Texas. I read the job description. It’s my kind of work. I can complete the project timely and within your budget.  I am an MBA having an advanced knowledg Lagi

€50 EUR dalam 7 hari
(101 Ulasan)
5.6
vsprybhanu

Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radi Lagi

€30 EUR dalam 3 hari
(89 Ulasan)
5.7
writingapp

Hi. I understood your project. I writen similar projects. I can write a excel vba app to match your 2 files. Great app writer for your projects. I have writen scraping, excel, googlesheet, csv, database app, macro, vba Lagi

€20 EUR dalam sehari
(17 Ulasan)
4.4
zaidur101

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

€8 EUR dalam 7 hari
(9 Ulasan)
3.5
Monirulop

Hi, I am Monir and it will be my pleasure to assist you with this project. I have read your project description. You can expect from me I strong commitment to a deadline, the highest quality, and a fluid/friendly comm Lagi

€19 EUR dalam sehari
(9 Ulasan)
3.4
hkh581e5c8f1cb8a

Hi there, Am a professional accountant in KSA, who has more than 6 years of REAL experience. With high Ms excel, research and finance management knowledge. Can offer you free samples and perfect results at fair price. Lagi

€19 EUR dalam 3 hari
(9 Ulasan)
2.9
ccoollavie

Dear sir, I’m an Excel teacher for engineers and I designed a specific tutorial about “array formulas”. These allow to make loops or equivalents inside a single cell without macros. Here is an example that you will Lagi

€50 EUR dalam sehari
(3 Ulasan)
2.3
inforafeesoft

Hi sir I'm a [login to view URL] Engineer Database Administrator and System Administrator Also Network Administrator I'm expert in Web Development,Database (My SQL,MS SQL,Azure,AWS,Mongo Db,Postgre DB,Magento ...etc), Java, Ja Lagi

€30 EUR dalam sehari
(1 Ulasan)
2.9
mkreza91

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

€22 EUR dalam 5 hari
(10 Ulasan)
1.7
gamaliel112181

Hi Sir/Ma’am, Good day! I am very interested on this project you just recently posted here. With my work experience and educational background I confidently know that I can deliver this project on the agreed SLA. I c Lagi

€14 EUR dalam 5 hari
(2 Ulasan)
0.3
kalpanachinni

Hello, I'm a professional and experienced data entry clerk and having lots of experience in Microsoft Excel. I'm pretty much interested in this project. I'm available to start immediately and deliver a quality work. I' Lagi

€19 EUR dalam 3 hari
(0 Ulasan)
0.0
egrigorya

Hi hi

€23 EUR dalam sehari
(0 Ulasan)
0.0
farabiislam888

Hello Sir, I am a specialist operator of data entry and excel.I have 5 years of experience with Data Entry and Excel.I have read about your project and I can help you. I have already completed data entry of several pro Lagi

€8 EUR dalam sehari
(0 Ulasan)
0.0
amiraziz1966

As I am Well-Experienced professional & Qualified person having a MBA degree (1989) in Finance also having my own firm with the name of “AIMS International Service" since 2016. So can perform and complete your JOB onli Lagi

€25 EUR dalam 6 hari
(0 Ulasan)
0.0