Find Jobs
Hire Freelancers

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

$30-250 USD

Terminado
Publicado hace alrededor de 9 años

$30-250 USD

Pagado a la entrega
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.
ID del proyecto: 6998130

Información sobre el proyecto

38 propuestas
Proyecto remoto
Activo hace 9 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 día
5,0 (113 comentarios)
6,1
6,1
38 freelancers están ofertando un promedio de $120 USD por este trabajo
Avatar del usuario
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 días
5,0 (878 comentarios)
9,3
9,3
Avatar del usuario
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 días
5,0 (566 comentarios)
8,6
8,6
Avatar del usuario
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 día
5,0 (1200 comentarios)
8,4
8,4
Avatar del usuario
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 días
5,0 (321 comentarios)
7,8
7,8
Avatar del usuario
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 día
4,9 (251 comentarios)
7,7
7,7
Avatar del usuario
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 días
4,9 (330 comentarios)
7,7
7,7
Avatar del usuario
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 días
5,0 (326 comentarios)
7,4
7,4
Avatar del usuario
i can do it for you quickly and exactly .
$222 USD en 3 días
4,9 (122 comentarios)
7,1
7,1
Avatar del usuario
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 días
4,9 (168 comentarios)
7,1
7,1
Avatar del usuario
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 día
4,8 (165 comentarios)
7,0
7,0
Avatar del usuario
Please send details ..................................................................................
$155 USD en 3 días
5,0 (26 comentarios)
6,4
6,4
Avatar del usuario
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 días
4,9 (118 comentarios)
6,3
6,3
Avatar del usuario
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 días
4,9 (38 comentarios)
5,6
5,6
Avatar del usuario
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 día
4,9 (18 comentarios)
5,7
5,7
Avatar del usuario
Hi! I can write this program for you. It can be macro or desktop app .
$70 USD en 3 días
5,0 (42 comentarios)
5,6
5,6
Avatar del usuario
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 días
4,9 (32 comentarios)
5,0
5,0
Avatar del usuario
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 día
4,9 (19 comentarios)
4,8
4,8
Avatar del usuario
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 día
5,0 (48 comentarios)
4,6
4,6
Avatar del usuario
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 día
5,0 (36 comentarios)
4,4
4,4
Avatar del usuario
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 días
5,0 (7 comentarios)
3,9
3,9

Sobre este cliente

Bandera de UNITED STATES
Auburn, United States
5,0
2
Forma de pago verificada
Miembro desde ene 19, 2015

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.