Find Jobs
Hire Freelancers

I need an excel expert

$30-250 SGD

Mbyllur
Postuar over 2 years ago

$30-250 SGD

Paguhet në dorëzim
I have a list of 50 thousand product codes in a file. In another file I have a list of 1000 product descriptions. Product description is a group of words, like a sentence, and contains the product code in it, but not in a specific location. It could be in the starting, ending, or in middle. I want a macro that can search for the product code in the description and if found, copy the code to a new column beside the description. The trick here is, one product code can be a substring of the other. For example, there are 2 product codes, 569 and 1025693456. when we are searching for 569, we cannot map it to 1025693456 as it is a substring.
ID e Projektit: 32824395

Rreth projektit

49 propozime
Projekt në distancë
Aktive 2 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
49 profesionistët e pavarur ofrojnë mesatarisht $133 SGD oferta për këtë punë
Avatari i Përdoruesit
"Sir, I am Excel, VBA and Coding Advanced Level Expert. This is basic work for me. I can complete this project with added quality. About me I am a Chartered Accountant with more than 4 years of experience from the worlds leading Accountancy and auditing firm ""PWC"". I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. It is my Sixth month here and I have 115+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards Arman Kakar "
$140 SGD në 1 ditë
4,9 (280 përshtypje)
7,4
7,4
Avatari i Përdoruesit
hi there, i will write the macro to get all product codes (full match and not partial match), and will get beside description, thanks..........................
$50 SGD në 1 ditë
5,0 (458 përshtypje)
6,9
6,9
Avatari i Përdoruesit
Since 2000 I am working on Visual Basic (VB6 and VB.NET) and MSSQL, and MS Access MDB. So more than 20 years of experience in Visual Basic to build any kind of Windows application. I have created Point of Sales, Inventory, Accounting, Back Office, Hardware Controller System, etc. If you need a good delivery of job and move this project to successful then message me, please.
$750 SGD në 2 ditë
5,0 (17 përshtypje)
6,3
6,3
Avatari i Përdoruesit
Good day In real life I'm making reports from big data ( CSV and xlsx files ) about 1.5mln lines I can do this job. It's easy job for me. Need some more clarifications and ready to do job I have 15+ year experience with Excel and Excel VBA Results will be excellent Thanks
$73 SGD në 1 ditë
5,0 (74 përshtypje)
5,6
5,6
Avatari i Përdoruesit
This macro is done, message me to get the file, if more than one product code found in one product description, all sub-string will be copied next to product code cell, the macro search Product_Code list in Product_Description list and write found product codes in cell next to product description as required, worked on your attached sample p_code p_description found p_code1 found p_code2 G5526018 G5526018 PVC Pipe 6MM * 12MM G5526018 2601 2601 2601PVCPipe 6MM * 12MM 2601
$100 SGD në 1 ditë
5,0 (17 përshtypje)
4,7
4,7
Avatari i Përdoruesit
⭐⭐⭐Excel VBA/Python Expert⭐⭐⭐ Dear sir. I am familiar with data processing. I have checked your project and I think I am suitable to your project. Hope to meet and have a talk about your project in detail. Sincere Regards
$140 SGD në 7 ditë
5,0 (3 përshtypje)
4,2
4,2
Avatari i Përdoruesit
Hi Do you need macro or if i do it in 1 time for you and share with you file.. will that work? Please message me I can do this Thanks
$30 SGD në 3 ditë
5,0 (11 përshtypje)
3,9
3,9
Avatari i Përdoruesit
Hello, I am professional freelancer with a Master's degree in Data analytics making me a suitable person for your project. I have more than 8 years of professional experience in Data analysis. Besides, I have skills in Visual Basic, Excel and Data Processing. For your reference, you can check reviews\ portifolio for all the projects I handled so far. Hope to connect with you on personal chat. Regards, Peter
$100 SGD në 2 ditë
4,7 (6 përshtypje)
3,8
3,8
Avatari i Përdoruesit
Hi, Dear! I have a full experiences and knowledge in Excel macro and VBA... I am confident to provide you best solution in time with reasonable budget. I can start Your work right now... And I will do my best for our works. Hope to discuss with you soon. Thanks & Best regards!
$165 SGD në 2 ditë
5,0 (8 përshtypje)
3,6
3,6
Avatari i Përdoruesit
Hi there! I'm an Excel VBA daily professional user. I'm not a developer, I use VBA to solve business problems for the UK construction industry, and US Manufacturing industries every day of the week! I'm confident we can get this done together. We need to look more carefully at the different ways in which product codes can be embedded together before we 100% agree on how best to move forward. I'm keen for a chat!
$199 SGD në 3 ditë
5,0 (2 përshtypje)
3,3
3,3
Avatari i Përdoruesit
Hello I am web developer and coder I have read your proposal enough. I have rich experience in vba macro with excel I can process data easily in excel using vbs I hope you will hire me. Vadym.
$140 SGD në 3 ditë
5,0 (1 review)
2,9
2,9
Avatari i Përdoruesit
Hi sir I have an experience on Ms office I have interest work with this project I can complete work with in a time And quality of work can be done I can do any hard work to this project Please give chance.......
$100 SGD në 7 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
I HAVE 6 YEAR EXPERINCE IN EXCEL ,I HOPE WILL COMPLETE YOUR WORK ON THE AS EXPECTED,I CAN PROVIDE THE A QUALITY WORK.
$100 SGD në 5 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
You can be sure that I will do this job in the best way possible. I'm a senior architecture student and I'm very good at computers. I can professionally use programs such as autocad, sketchup, lumion, adope photoshop, microsoft word, microsoft excel. If you want a security deposit this doesn't feel right to me and I will not pay a security deposit.
$100 SGD në 1 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
Maybe you’re new to the Freelancer platform. Maybe you’ve been at it for a while but have yet to be awarded that elusive first project. Odds are it’s not your skillset that’s lacking. There’s an art form to writing an attention-grabbing bid that makes you stand apart from the crowd and puts your considerable skills front and center. We’re going to teach you how to do it.
$140 SGD në 7 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
hii my name is parth. i am information tachnology student at Dharmsinh Desai university, i know basic of data processing and also know excel so I can help you I am work hard and make best result for you.
$30 SGD në 7 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
I am expert in Excel I read your project description and O am very interested in your project with 100% accuracy looking forward to hearing.
$30 SGD në 5 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
Good Day, I have read and fully understand your requirements. You have excel files, and in description column you have product code, which you want to extract and put on next column. I can create a program for you in c# or python script which will automatically do this job for you. I can do this really quick and offer you very good budget. You can pay me when you are satisfy with the results. Please message me back so we can start. Thanks! Asad.
$30 SGD në 1 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
Dear sir I have sound knowledge and experience in ms word, ms excel and ms powerpoint. I have also good typing speed. I am using this software from more than 10 years. I have also knowledge of accounts and finance. I have knowledge of bills payable , bills receivable, books keeping, books finalization, tds and gst. I will complete my task on time with accuracy. I am also good in article writing.
$120 SGD në 7 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
I hold strong knowledge in Excel with macro and VB command. I have more than 15 years of work experience in excel data base where I use macro and VB for data analysis. I can perform this message within in stipulated time.
$140 SGD në 7 ditë
0,0 (0 përshtypje)
0,0
0,0

Rreth klientit

Flamuri i SINGAPORE
Singapore, Singapore
0,0
0
Anëtar që nga shk 3, 2022

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.