Find Jobs
Hire Freelancers

VBA Excel Macro Programmer Needed Right Now

$8-15 USD / hour

Closed
Posted about 4 years ago

$8-15 USD / hour

Need VBA Programmer to help write Macros right now in real time either via messaging or over the phone. Have several tasks that need to be done, so this could be ongoing. First task is as follows: Find unique skill types from column "SkillType" and create a new column for each, then copy data from neighboring column that is associated with this skill type and paste into row 2 of the new column, separate each skill by a bar " | " OR add a bullet and each skill be on its own line. Here is a breakdown of how it should probably work: 1. Search for specific column by heading name: "SkillType" 2. Find first non empty cell in column "SkillType" and return cell address (ex. $BQ$4) 3. Count how many instances of that skill type exist and set as integer i 4. Copy each unique skill type as String from column BQ and create new column (2 columns over in BS) with copied string as heading name 5. From original cell ($BQ$4) copy data from neighboring cell in column next to this (ex. starting with $BR$4) and paste into row 2 of new column - iterate down the neighboring column as many times as counted (integer i) starting with same cell $BR$4, copying and pasting data into row 2 of the newly created column, separated by a bar & " | "& 6. Find the next unique skill type from column "SkillType" and do the same See spreadsheet samples attached (Edited version is before and Complete version is how all columns should look like in the end. Will need to use similar logic for other "sections", including education, experience, publications, and achievements.
Project ID: 24438412

About the project

38 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
38 freelancers are bidding on average $13 USD/hour for this job
User Avatar
Hello, I can help you with your project - VBA Excel Macro Programmer Needed Right Now 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/schoudhary1553 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, Sandeep
$20 USD in 40 days
4.9 (608 reviews)
8.5
8.5
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
$18 USD in 5 days
5.0 (345 reviews)
7.5
7.5
User Avatar
I have 4 yrs in Programming, Automation & more importantly delivering projects as required & in quick turn around time. I work full time as Freelancer & Blogger. I will be able to start your work immediately. My Main Skills: - Excel - VBA - Python - Web Scraping - MS Office Word, Outlook, Access, PPT Skill Set in Detail: - Office & Web Automation & Blogging on Office Tricks & tips. - Python Programming, Web Scraping - Data Scraping - Manual to Automatic updates in Excel - Excel Pivot Charts & Tables - Excel Auto Filter, Vlookup, Formula Assistance - Excel to Access - User Forms in Excel - Calendars in Excel - Bulk Files Processing in side a Folder - Folder Operations - Sending Email from Excel - Extract Data from Webpages Requesting to Contact before ordering. This would enable me to give a feasible custom offer. Please drop a message once you feel comfortable with my profile & lets get started with a feasible amount. Thanks for your time
$12 USD in 40 days
4.9 (433 reviews)
7.6
7.6
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Willing and looking forward to working with you. Thank you, Regards.
$15 USD in 25 days
5.0 (202 reviews)
7.1
7.1
User Avatar
Hi, Keen to work on this project. Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word, MS PowerPoint, MS Outlook automation. I have done good amount of work in VBA. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, Google maps, sending email through Outlook, Image handling, Userforms, 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
$20 USD in 40 days
4.9 (208 reviews)
6.9
6.9
User Avatar
Hi, Reading your project description about finding a VBA Programmer to help write Macros in real time either through messages or over a phone, makes me feel like you have me in mind when creating the project. I have all it takes to deliver. Rather than fill this proposal with a list of qualifications, I want to complete a part of this project as a proof of concept before you award this project. This is so that you can be confident of the hands you will entrust this task. If you are satisfied with the result, you can go ahead and award the project. I’d love to discuss more on what would make this project a success for you. Can we have a quick chat? Thanks for your time
$25 USD in 40 days
4.9 (80 reviews)
7.1
7.1
User Avatar
Hello I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel/VBA. I'm professional Ms Access/Excel/vba coder. I'm coding in vba since Ms Office 97 released. Please visit (where I'm working basically): https://www.freelancer.com/u/zu02?w=f I see this is an interesting task for coding. I'll do my best to make it. I hope hearing from you soon. Thank you for your consideration and Regards, Zurab
$14 USD in 40 days
4.8 (55 reviews)
6.2
6.2
User Avatar
Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radio Buttons, List Boxes etc. in excel VBA. I also have expertise in Manipulating and Exchanging Data in Multiple Sheets, Using Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. I have done mostly Excel VBA Programming jobs. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start please message me to discuss your project in more details. Thanks, Virendra
$12 USD in 40 days
4.9 (145 reviews)
6.2
6.2
User Avatar
Hello, ⭐⭐⭐⭐⭐ i am expert in this kind of jobs samples of my excel VBA jobs ⭐⭐⭐⭐⭐ https://www.freelancer.com/projects/excel/Create-Excel-Spreadsheet-Macro-that/ https://www.freelancer.com/projects/excel/Make-VBA-code-run-itself/ https://www.freelancer.com/projects/visual-basic/Retrieving-data-from-other-different/ https://www.freelancer.com/projects/Excel/Multiple-Entry-Excel-Macro/ https://www.freelancer.com/projects/Excel/VBA-loop-code-sum/ https://www.freelancer.com/projects/Excel/Complete-Some-Advanced-VBA-Microsoft/ https://www.freelancer.com/projects/Data-Entry/Capture-data-from-website-website-12641885/ https://www.freelancer.com/projects/php/Write-some-Software-12250366/ ⭐⭐⭐⭐⭐ waiting your answer Regards
$8 USD in 40 days
4.9 (80 reviews)
4.9
4.9
User Avatar
Hello, I am an excel/VBA specialist and I would like to assist you in this project. I'll do my best to meet your needs. If you decide to contact me you won't be disappointed. Regards
$12 USD in 40 days
5.0 (21 reviews)
4.6
4.6
User Avatar
Hi there, I am able to work on your work over the internet (remotely via teamviewer). I have completed similar project in the past like this one. I hope to hear from you soon.
$12 USD in 40 days
4.8 (46 reviews)
4.8
4.8
User Avatar
Hi! I am a entrepenour and Excel/VBA/Macro ans Google Scrpit , Google Sheets expert. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts (script). Please contactme to send you a Demo draft of your -very nice explained- proyect. Regards, Juan
$12 USD in 40 days
5.0 (20 reviews)
4.7
4.7
User Avatar
Hello, I can help you with your projects on vba (had more than 10 years of experience working with it), please send me a message with more details and with the OK, and I can start working on it immediately.
$12 USD in 20 days
5.0 (49 reviews)
4.7
4.7
User Avatar
Hello. I just read your posting. It sounds like you need an Excel & VBA expert. I have rich experience in this field and I can import C++ DLL for security of your project if you need. I have experience in ACM ICPC so I always use the best algorithm. Budget is not important for me and trust is very important for me. I will perfectly complete your project in a short time. If you give me a chance, I will do my best for you. Regards, Daniel Ramos Garcia
$15 USD in 40 days
4.6 (2 reviews)
4.3
4.3
User Avatar
I am very good at this work and can deliver with very high quality .
$12 USD in 40 days
5.0 (2 reviews)
2.7
2.7
User Avatar
Hi Greetings of the Day, I am interested in this task, I have extensive exp in macro writing. I am full time freelancer carrying 15 yrs of experience in VBA, Web and Windows development and Mobile development using ASP.Net, C#, SQL server, Xamarin, WebAPI, XML, Cr Reports etc. I have extensive experience in writing VBA/Excel codes/macros. Please feel free to contact me. Thanks.
$12 USD in 40 days
5.0 (1 review)
1.8
1.8
User Avatar
Hello, I read your project description and understand all. I have 20 years in Database development, Programming, System Analysis, Data Analysis using Ms. Access, Ms. Excel, VBA VB6, Vb.net, C# and MS SQL server I will make the perfect product what you want. I promise to complete your project within your time and budget beyond your expectations. I am willing to work at lower pay. Let me know when we can discuss and share all.
$8 USD in 40 days
5.0 (2 reviews)
1.5
1.5
User Avatar
I can do this
$12 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am the best suited candidate because I am proficient in MS Excel, JSON, and various forms of Data Science that require logic.
$17 USD in 44 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hii i am arvind singh I am from india iam interested in your work trust me I am excellent in this types of work give me chance to prove me
$11 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Fort Lauderdale, United States
5.0
1
Member since Feb 11, 2020

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.