Find Jobs
Hire Freelancers

microsoft Execel ,VB

£10-20 GBP

Annulleret
Slået op over 10 år siden

£10-20 GBP

Betales ved levering
I receive my Job Daily By excel Spreed sheet On one of the column there is big description of job inside description it is telling me how many parts I need to collect from Company and there is Part number after the word PART comes part number Part numbers usually after the word PART comes part number I need a program can read Description that is maximum 2 sentences and find part number and return it back to into the other column I think even it can be function can do it as well why do I need this Function because when I get Jobs sometimes it is 20 jobs inside file and I must to read all description to find part number
Projekt-ID: 5038185

Om projektet

36 forslag
Projekt på afstand
Aktiv 10 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
36 freelancere byder i gennemsnit £16 GBP på dette job
Brug Avatar.
Hello - I am an Expert Techno-Functional Analyst in lots of arenas of IT industry including Excel Macros. I am an Engineering Graduate with an MBA degree. If you see I am among the niche bidder who has 0 failed projects because I work till the fullest satisfaction of employers and you can find the same in any of the past reviews of mine. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Thanks, Jay
£15 GBP på 3 dage
5,0 (767 anmeldelser)
8,6
8,6
Brug Avatar.
Hi shahramphp, Shall provide you with an Excel macro script to automatically filter out the Part Numbers found under Description column. Let me know. Regards, Arul
£20 GBP på 1 dag
5,0 (174 anmeldelser)
7,4
7,4
Brug Avatar.
A quick job for excel expert.....lets start...I will provide a small VBA add-in for this, which will show button on your Excel Ribbon all the time....When you get data file, you can press this button....The button will extract parts from description.
£17 GBP på 1 dag
4,9 (261 anmeldelser)
6,8
6,8
Brug Avatar.
Hi Mate. Its a 30 minute job to get you the part number from description. Lets start and get it done. Regards.
£21 GBP på 1 dag
5,0 (74 anmeldelser)
6,8
6,8
Brug Avatar.
Hey shahramphp, this is very simple to achieve.... do you mean to extract this text(s) "8MDY2=1", right ? this is definitely feasible... please reply for more details... thanks !
£10 GBP på 1 dag
4,8 (161 anmeldelser)
5,9
5,9
Brug Avatar.
Such jobs are my daily practice. Please, see PMB for a sample file! My bid includes also the macro doing the job. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files and hosting command buttons and other controls if necessary. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Can you specify the maximum number of part numbers within a Description? Regards! Sorry I have just now noticed than Freelancer stopped PMB. Please, initiate a chat to allow me to send you my sample file!
£20 GBP på 2 dage
4,9 (63 anmeldelser)
5,7
5,7
Brug Avatar.
Hello there. I have high Excel and Visual Basic skills with great professionalism. I study electronics and computer engineering at Oporto university and I'm looking for work to fill the blanks on my schedule. I noticed that on the L1 Cell you have "Part:" three times, you want the number in front of those "Part:" to be extracted, right? I'll need to know to which column and will have to know what separator you want for each "Part:" (for example "8MDY2 / 8MDY2 / 9014G") I'll also need to know if you want the "=1" to appear or not. I would gladly appreciate this opportunity to work with you. Best regards, Bruno Martins
£15 GBP på 1 dag
5,0 (59 anmeldelser)
5,4
5,4
Brug Avatar.
Dear Sir, I'm ready to help with your task right now. Kind Regards, NourElDeen
£15 GBP på 1 dag
5,0 (57 anmeldelser)
5,5
5,5
Brug Avatar.
Dear Sir/Madam, it's an easy task, I can do it in less than 1 hour. I have 12+ years of extensive Excel experience.
£10 GBP på 0 dag
5,0 (65 anmeldelser)
5,4
5,4
Brug Avatar.
Hi I am an expert in Excel and VBA Programming in Excel. I have experience in Excel Designing, Excel VBA Programming, Providing Business Solutions in Excel and Creating Dashboards in Excel for Presentations. I am interested to work for your project. Please give me a chance. I have handled many projects involving data manipulation handling, business solutions, Excel automated dashboards, Report Generation and Excel Applications. If you offer me your project, I can start immediately and deliver the job within 2 days after testing (QA) . I guarantee 100% accuracy for my deliverable. I do hope you'll give me the honourable chance to work with you and help me with making my mark on freelancer.com. I will take your project as the priority job and will complete your work in minimum time with 100% commitment. Thanks Fibin
£10 GBP på 1 dag
4,9 (53 anmeldelser)
5,4
5,4
Brug Avatar.
Hi, Greetings. I have checked the file you attached and looked into the Column having Description in it. In your sample excel file the description column contains words Part as Part: and then the values like 8MDY2=1 and 8MDY2=1 and 9014G=1 etc As you can see in above 8MDY2=1 is repeated two times in the Description so please tell me you need only one value for repeated part ORl you want them all. Also please tell where you want to place those values after extracting them from Description. I will create a Formula that will take the cell address of the column having the description and will return the Part Numbers as above. Please contact me so we can discuss more on the same. Please also check my tremendous 116 reviews for my quality work. I hope we can do business long lasting. Look forward to hear back. Thanks Dhirendra
£15 GBP på 1 dag
5,0 (23 anmeldelser)
4,8
4,8
Brug Avatar.
I am very proficient in dealing with word, ppt, access, excel files, and good at VBA programming, I have exceed 6 years of VBA programming experience now. I made many audit program using excel, and I am very efficient, which u can check my review. I am a good programmer, i can let most of the process automation. Please trust me, and let expert do it.
£21 GBP på 0 dag
5,0 (3 anmeldelser)
4,4
4,4
Brug Avatar.
**********I've done lot of similar projects*********** Good Day!... I'm an Excel VBA Automation Expert. Having 6+years of Exp. Have developed & designed various excel based projects,dashboards,templates & trackers by using Excel VBA & also with Advanced Excel Functions. I can finish your project very easily in few mins/by max a couple of hours. Please check my Portfolio to know my programming skills. & Check my client's review as well to know my consistent quality service. Kindly award this project to me. Glad to assist you. Looking forward from you.
£20 GBP på 0 dag
4,7 (21 anmeldelser)
4,4
4,4
Brug Avatar.
Hello I am VBA for Excel Programmer and can do your job as per your requirement and expectation. Let know when to start Regards Nikhil
£18 GBP på 3 dage
4,9 (18 anmeldelser)
3,8
3,8
Brug Avatar.
Hi, I am VBA expert, I can finish your project on less than an hour. I have a look on your attached file, and as you show, part number is: "8MDY2", is it right? Please contact me and get it immediately. Thank you very much
£17 GBP på 0 dag
5,0 (14 anmeldelser)
3,6
3,6
Brug Avatar.
Hi. Can do that now. File is ready to be sent back to you. If you want it just accept my bid. Thanks
£17 GBP på 0 dag
5,0 (2 anmeldelser)
3,1
3,1
Brug Avatar.
HI there, As a professional Excel developer, I'm happy to put this together for you very quickly - if you hire me in the next hour or so, I can commit to having the formula back for you before close of play today! It's a relatively straightforward formula, and you can copy it down to fill any number of cells. I'm based in the UK, so if you'd like to chat over the phone, that's fine, although your example and brief have made what you want very clear, so that shouldn't be necessary! Let me know if you have any questions, or would like to talk a little more about the project. Hope to hear from you soon! Iain
£15 GBP på 1 dag
5,0 (3 anmeldelser)
2,5
2,5
Brug Avatar.
Sir, Greetings! Ready to finish your task right away.. Need on clarification... In the example you provided, the description column contains 3 instances of "Part:".. which one you need from that ?
£20 GBP på 0 dag
5,0 (1 bedømmelse)
1,7
1,7
Brug Avatar.
Hi Shahramphp, Looking at your sheet, there are actually multiple part numbers in the description, however I could write a macro that would generate a list and include a Job ID so that you can easily print off the list of part numbers for each job. All the best, Ben
£20 GBP på 1 dag
5,0 (2 anmeldelser)
1,6
1,6
Brug Avatar.
Hello, I can do this now. Give me 30 minutes to do this. Thanks! I will provide you documentation and explanation on how to do this. Kindly award me this project. thanks! Derrick
£10 GBP på 3 dage
5,0 (1 bedømmelse)
1,0
1,0

Om klienten

Flag for UNITED KINGDOM
United Kingdom
0,0
0
Medlem siden okt. 16, 2013

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.