Find Jobs
Hire Freelancers

Create a macro to select a certain info from one spreadsheet and form another with it

$30-250 USD

Complété
Publié il y a plus de 9 ans

$30-250 USD

Payé lors de la livraison
I need a macro that will open a spread sheet either in excel or csv, then will open a text file from a folder, get the first line from that text file, search that info in a certain column in the spreadsheet, then copy all of the rows that it has found with that information into another spreadsheet. Then new spreadsheet that has been created will be saved in the same folder that contains the text file. The new spreadsheet will be saved titled as the search term from the text file. When this is done, the macro will move to the next line in the text file and repeat the process until all the lines in the the text file are done. Let me know if I have to buy a certain macro software or if you can provide that too.
N° de projet : 6998130

Concernant le projet

38 propositions
Projet à distance
Actif à il y a 9 ans

Cherchez-vous à gagner de l'argent ?

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux
Décerné à :
Avatar de l'utilisateur
Hello, I can get you a macro written within the next 3 to 6 hours. I can start the work now. Let me know if you are interested. Thanks
$30 USD en 0 jour
5,0 (113 commentaires)
6,1
6,1
38 freelances proposent en moyenne $120 USD pour ce travail
Avatar de l'utilisateur
Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am the only bidders who has full 5 star rating, zero failed projects and 99% completion rate since I do not bid on projects which I am not certain of. 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. Also I will provide you with a working version of file before you consider awarding me the project. Thanks, Jay
$75 USD en 3 jours
5,0 (878 commentaires)
9,3
9,3
Avatar de l'utilisateur
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$100 USD en 8 jours
5,0 (566 commentaires)
8,6
8,6
Avatar de l'utilisateur
Hi, I am good at excel and macros. I am working on a project of the similar way. Please refer the allocated project list / working project. It is about to complete. I will produce the results with 100% accurate. Looking for your response soon.
$30 USD en 0 jour
5,0 (1200 commentaires)
8,4
8,4
Avatar de l'utilisateur
Hi. I ll code the VBA macro in 1-2 days. It will loop through all the lines, open the txt file, create the new spreadsheet, save it in the same file as the txt file. I have to get a sample Excel file + the folder with the text files. We will make just a sample together to clarify all before coding. Ready to start. Thanks
$88 USD en 3 jours
5,0 (321 commentaires)
7,8
7,8
Avatar de l'utilisateur
Hi, I'll be happy to help you with this project. I take pride in accuracy, timely completion and support within reasonable time after completion. Please feel free to message me if you need to discuss any questions
$120 USD en 1 jour
4,9 (251 commentaires)
7,7
7,7
Avatar de l'utilisateur
Hello sir, I am PREFERRED freelancer in excel and related skills on this forum with 200+ five star reviews. I have understood your requirement and I am ready to start the implementation immediately. Looking forward to discuss with you about the project
$250 USD en 2 jours
4,9 (330 commentaires)
7,7
7,7
Avatar de l'utilisateur
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and macros. Check my reviews. They speak for themselves. Best regards
$127 USD en 4 jours
5,0 (326 commentaires)
7,4
7,4
Avatar de l'utilisateur
i can do it for you quickly and exactly .
$222 USD en 3 jours
4,9 (122 commentaires)
7,1
7,1
Avatar de l'utilisateur
Hi: You do not have to buy any software. I can design a macro in Excel that will do all the work. Here's my understanding of your requirements: You have a folder with text. You want the macro to open the text file in background, read the first line and search for that term in another Excel file. Then copy all rows, where there is a match for the searched item, to a new file and save it in the same folder as text file. I have 100% completion rate on freelancer and have received 5-star feedback on projects. More than 80% of my projects are related to Excel and macro. Please connect with me to discuss more.
$77 USD en 2 jours
4,9 (168 commentaires)
7,1
7,1
Avatar de l'utilisateur
Dear friend, Hope you are well. I would like to give a worm welcome for your excellent project. I am ready to do this job for you. I have enough experience on it actually what you are looking for. I will do your work with more accuracy, fast & deliver in a right time. I am promising you that I will cross your expectation. If you kindly give me this project I am sure our friendly relation & faith will go on for the next project. I am also promising I will do this job within your budget & time. God bless you. Have a good day. Thank you. Yours sincerely, Md. Mayaraj Mahabub Raj User name: “rajstk”
$30 USD en 1 jour
4,8 (165 commentaires)
7,0
7,0
Avatar de l'utilisateur
Please send details ..................................................................................
$155 USD en 3 jours
5,0 (26 commentaires)
6,4
6,4
Avatar de l'utilisateur
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 220 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. I will create macro. No need to buy any other software. Thanks.
$150 USD en 7 jours
4,9 (118 commentaires)
6,3
6,3
Avatar de l'utilisateur
Hi, I am working as Lead Pricing Analyst in a Fortune 500 MNC. I have worked on designing, implementing and analyzing ACBC (conjoint) surveys, pricing models, income statements, business analysis etc. Prior that I have completed MBA and bachelors in Engineering. I have worked extensively on excel and VBA in my job and here on freelancer as well. I believe I can help in your work. Please have a look at reviews provided by previous employers. Please contact for further discussion. Regards! Vikas
$97 USD en 3 jours
4,9 (38 commentaires)
5,6
5,6
Avatar de l'utilisateur
Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have been freelancing for over 2 years. But I joined this site just a month ago. Within a month I won two of tough contests held on this site. This says a lot about the quality of my services. I have worked on lot of advance excel dash boarding and VBA coding and delivered them successfully with high quality. Few of my projects are 1) Fully automated end to end business model for 3B $ healthcare company. Scope : Global Forecast for 8 products, cost modelling, product selection and prioritization, scenario analysis 2) Training Management System for an MNC. Scope : Training calender, TL can nominate his associates to relevant trainings, sends reminders, annual training summaries etc 3) BD&L model for an MNC ; Market analysis, geography analysis, opportunity analysis, SWOT, cost benefit analysis 4) Physician segmentation and Targeting ; Physicians of Latin American were segmented in 3 tiers based on several factors, exhaustive call planning strategy was built with additional features like territory alignments, productive call frequency etc I delivered many more projects of high value and quality. I am confident that I can deliver your project with high quality. Looking forward for your response so that I can start working immediately Thanks and Regards.
$150 USD en 1 jour
4,9 (18 commentaires)
5,7
5,7
Avatar de l'utilisateur
Hi! I can write this program for you. It can be macro or desktop app .
$70 USD en 3 jours
5,0 (42 commentaires)
5,6
5,6
Avatar de l'utilisateur
I have been developing applications in both Access and Excel for 20 years with extensive use of VBA. I have developed several applications for Freelance clients, please see Feedback and examples in Portfolio. I am UK based, a native English speaker, available on Skype and currently on UTC I am available now and would aim to finish in 3 days Please contact with more detail and I will submit a full proposal.
$80 USD en 3 jours
4,9 (32 commentaires)
5,0
5,0
Avatar de l'utilisateur
Hello, I can provide you with a small desktop application written in Perl it will handle all excel operations you intended. u need not install Perl on ur machine. kindly get back. Thanks, Shweta
$150 USD en 1 jour
4,9 (19 commentaires)
4,8
4,8
Avatar de l'utilisateur
Greetings for the Day!!! I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details Thanks Prabakar M
$83 USD en 1 jour
5,0 (48 commentaires)
4,6
4,6
Avatar de l'utilisateur
I have over a decade of experience working with excel as bot a professional data scraper, and a data analyst. What you are asking for is actually quite simple to do and would only take me 1-2 hours to complete. I look forward to working with you!
$40 USD en 1 jour
5,0 (36 commentaires)
4,4
4,4
Avatar de l'utilisateur
Dear, Regarding my qualifications, I hold a Master's degree in Electrical Power Systems and a Bachelor's degree in Engineering (Electrical) and I've been using Matlab/Excel/VBA for 5+ years. Regarding The project: Please more info in PM Thank you. :) I await your reply. With Kind Regards Boris
$250 USD en 5 jours
5,0 (7 commentaires)
3,9
3,9

À propos du client

Drapeau de UNITED STATES
Auburn, United States
5,0
2
Méthode de paiement vérifiée
Membre depuis janv. 19, 2015

Vérification du client

Merci ! Nous vous avons envoyé un lien par e-mail afin de réclamer votre crédit gratuit.
Une erreur a eu lieu lors de l'envoi de votre e-mail. Veuillez réessayer.
Utilisateurs enregistrés Total des travaux publiés
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Chargement de l'aperçu
Permission donnée pour la géolocalisation.
Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.