Find Jobs
Hire Freelancers

Simple Excel Macro to Data Purge - VBA

$10-30 USD

Closed
Posted about 4 years ago

$10-30 USD

Paid on delivery
Hi, I have a very simple job. I have about 100 excel documents which require purging. Please see sample document attached. 1. Step 1 - I require the rows to be purged based on a data field match. In the example, I would need a method to delete all rows except for the ones with the keywords "keyword1" and "keyword2". Meaning, all of the junk rows should be delete. 2. Step 2 - I require the columns to be purged based on a data field match. For eg, I require all columns to remain in the document which match "keyword1, keyword2, header2, header5". What this would do is delete columns B, D, E, G, H, and I. 3. Step 3 - Match the column with a specific header name, and replace the cell below it with a particular value. This would only be for 1 column only. In the attached example, I would like to find the column named "header2" and replace the cell beneath it from "content2" to "data2". I would like some basic instructions on how the macro is setup so I can modify it with my real data, as the attachment is an example and mimics the real data Thanks
Project ID: 23611522

About the project

32 proposals
Remote project
Active 4 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
32 freelancers are bidding on average $29 USD for this job
User Avatar
Hi, I have understand the project requirement & interested to work for this project. I will start right now and will finish within 2 hours. Please send a message so we can discuss more & start the project. Thanks.
$30 USD in 1 day
5.0 (307 reviews)
7.3
7.3
User Avatar
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 260 projects successfully completed here. Contact me to discuss the details. Best regards
$50 USD in 3 days
4.9 (140 reviews)
6.8
6.8
User Avatar
$ 25 Only ----- In just 2 Hours ----- Excel VBA Macro Coding, Formula Generation and Automation Process Expert with 5* rattings---- I can start right now, please message me to discuss more.
$25 USD in 1 day
5.0 (245 reviews)
6.4
6.4
User Avatar
Hi, Keen to work on this project. I am well versed with writing macros in Excel, Word etc.. I have used written macros extensively for Excel, MS Word, PowerPoint etc. for automation of various tasks. I have done good amount of work in Excel macro handling. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, sending email through Outlook, Image handling, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet.etc. I have also handled various Excel tasks. It includes creation of formulas using arrays, Pivot table creation, Creation of graphs, Filtering, Removing duplicates, Data analysis, Data entry works, etc. I have more than 15 years of experience to my credit. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks
$25 USD in 1 day
5.0 (131 reviews)
6.4
6.4
User Avatar
Hello! I can resolve this using a VBA script and I can explain you how to modify the script. Is 30$ your maximum budget? I am available to start now. Thank you!
$30 USD in 1 day
5.0 (39 reviews)
5.9
5.9
User Avatar
Hi. I am ready to write your project Write apps on your demand in many languages (Visual Basic, VBA, VBS, .NET, C#, JS, Python, Java, PowerShell) Write database apps including many db formats: MS Access, MS SQL, SQL Server, MySQL, SQLite, PostgreSQL, Firebird Write Automation apps including: * Automation Desktop apps. Some examples: Automation Playing Games, Automation Start/Stop/Click 3rd party apps * Automation Web apps. Some examples: Automation Web Scraping apps, Automation Web Crawling apps * Automation Data Processing apps: Automation formatting data to a specified template * Automation Data, Document Converting apps * Automation Macro, VBA for all apps in MS Office (Excel, Word, Outlook), OpenOffice, GoogleSheet * Automation Installers/Setups * Convert your Manual tasks to Automation solutions Write Web Service, Web API, Desktop API apps. Some examples: Google API, Bing API, Facebook API, MS API Fix/Solve any errors in your OS, apps
$30 USD in 1 day
5.0 (138 reviews)
6.1
6.1
User Avatar
Hi, I can develop macro to purge data of excel documents. I am experienced Data Analyst and Macro Developer and have done many similar projects. I have excellent knowledge and experience of Manipulating strings. So, can do this job nicely. Ready to start please message me to discuss your project in more details. Thanks, Virendra
$30 USD in 1 day
4.9 (101 reviews)
5.9
5.9
User Avatar
Hi I have very good experience working with XL and creating VBA macros to create the tools you need for this work. Regards. Reuben
$30 USD in 1 day
5.0 (12 reviews)
4.7
4.7
User Avatar
Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this due to my experience with VBA and Excel. It will be quick and accurate. If interested, we can discuss this further on chat.
$30 USD in 1 day
4.9 (14 reviews)
4.4
4.4
User Avatar
Hi Sir I have checked you complete description. I will write a macro to perform all the data cleansing as mentioned by you Regards
$50 USD in 7 days
5.0 (53 reviews)
4.5
4.5
User Avatar
Hi there! Here's my plan. I will create a file for you that allows you to input those 3 criteria you labelled (Rows to retain, Columns to retain, Data to replace). Will show you a preview before you award the project. Cheers!
$30 USD in 1 day
5.0 (7 reviews)
3.5
3.5
User Avatar
Hello Dear i'm new in freelancer.com but i'm a developer with +12 year experience and expert in ms excel: formula, macros and vba, excel connection with db, charts and ..., also i'm teacher of ms excel i read project description and see attached file, i already done many projects in ms excel for big companies, specially for worksheets merge(with many count of files), data cleanup and advanced data matching also in define all variable that you want to change at top of macro with description for easy to change by you i will provide 100% satisfaction of you, i need your positive review for my profile :) thanks so much
$10 USD in 1 day
5.0 (8 reviews)
3.6
3.6
User Avatar
Hi, We have worked on several excel macro projects. We have gone through the instructions given above and we can get the work done for you. We might need few clarifications and we would be good to start. Kindly allocate the project so that we can start the work. Thank you.
$20 USD in 7 days
5.0 (11 reviews)
3.2
3.2
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/whitehorsetechn?w=f I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Ramesh
$100 USD in 2 days
4.2 (4 reviews)
3.9
3.9
User Avatar
I have previous experience and enough time to complete this task as well as you requirements. Just send more details on Chat.
$30 USD in 1 day
4.8 (6 reviews)
2.6
2.6
User Avatar
Hello sir/ma, I'm interested in taking this task up for you. I'm a professional and also have good command over MS Excel especially pivot table, charts, advanced formulas, formatting, Excel VBA, R Programming Language, Data Processing, Excel, Web Scraping, Web Search and Data Entry as well. I’m honest, creative and a unique person to carry out your tasks given to me. Leaving your project on our hand is privileged; we'll make sure that the project is done in a perfect way and do our best until you were satisfied. I would love to discuss this project with you and meet your exact requirements. I am confident I can provide you with top-notch materials that will fit your needs. I'm proud of my work on being professional, of the highest quality and always delivered on time.
$10 USD in 1 day
5.0 (1 review)
2.2
2.2
User Avatar
I have the macro ready for you. I can attach the file to a chat as soon as you contact me. No problemo to get you a macro to purge and adjust your sheet as you described. I will use meaningful names for the variables and include some comments in the various sections of the code so you can understand what each section is doing. A macro is far easier for you to use than trying to use cell formulas that you would need to keep manually copying cells as your spreadsheet grows.
$10 USD in 1 day
5.0 (1 review)
1.6
1.6
User Avatar
Hi I have a better proposal for you. instead of giving you a macro file to use it. I will show you how to do it using simple excel formulas. This will help you repeat the same process for all the files you have. I will be happy to work with you. Regards,
$10 USD in 1 day
5.0 (3 reviews)
0.9
0.9
User Avatar
Hi. I am interested to work on this project. Please chat with me for more details.. Thank you for your trust.
$15 USD in 2 days
5.0 (2 reviews)
0.9
0.9
User Avatar
Hello Project Owner, Good Day to You! I've completed your requirement in a simple, yet profound way. Took an hour total to complete it, which does as per the requirements you had mentioned here. Kindly accept my quote, and I'll provide you the instructions on how to use this file, which are very basic. The file is ready to share IMMEDIATELY. Looking forward to work with you in more similar projects. Thank You// Sriram, from India.
$25 USD in 1 day
5.0 (1 review)
0.6
0.6

About the client

Flag of CANADA
Toronto, Canada
5.0
20
Payment method verified
Member since Oct 19, 2009

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.