Find Jobs
Hire Freelancers

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

$30-250 USD

Completed
Posted over 9 years ago

$30-250 USD

Paid on delivery
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.
Project ID: 6998130

About the project

38 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 in 0 day
5.0 (113 reviews)
6.1
6.1
38 freelancers are bidding on average $120 USD for this job
User Avatar
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 in 3 days
5.0 (878 reviews)
9.3
9.3
User Avatar
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 in 8 days
5.0 (566 reviews)
8.6
8.6
User Avatar
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 in 0 day
5.0 (1200 reviews)
8.4
8.4
User Avatar
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 in 3 days
5.0 (321 reviews)
7.8
7.8
User Avatar
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 in 1 day
4.9 (251 reviews)
7.7
7.7
User Avatar
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 in 2 days
4.9 (330 reviews)
7.7
7.7
User Avatar
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 in 4 days
5.0 (326 reviews)
7.4
7.4
User Avatar
i can do it for you quickly and exactly .
$222 USD in 3 days
4.9 (122 reviews)
7.1
7.1
User Avatar
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 in 2 days
4.9 (168 reviews)
7.1
7.1
User Avatar
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 in 1 day
4.8 (165 reviews)
7.0
7.0
User Avatar
Please send details ..................................................................................
$155 USD in 3 days
5.0 (26 reviews)
6.4
6.4
User Avatar
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 in 7 days
4.9 (118 reviews)
6.3
6.3
User Avatar
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 in 3 days
4.9 (38 reviews)
5.6
5.6
User Avatar
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 in 1 day
4.9 (18 reviews)
5.7
5.7
User Avatar
Hi! I can write this program for you. It can be macro or desktop app .
$70 USD in 3 days
5.0 (42 reviews)
5.6
5.6
User Avatar
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 in 3 days
4.9 (32 reviews)
5.0
5.0
User Avatar
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 in 1 day
4.9 (19 reviews)
4.8
4.8
User Avatar
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 in 1 day
5.0 (48 reviews)
4.6
4.6
User Avatar
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 in 1 day
5.0 (36 reviews)
4.4
4.4
User Avatar
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 in 5 days
5.0 (7 reviews)
3.9
3.9

About the client

Flag of UNITED STATES
Auburn, United States
5.0
2
Payment method verified
Member since Jan 19, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.