Find Jobs
Hire Freelancers

Excel VBA Script (3 Functions)

$10-30 USD

Completed
Posted over 3 years ago

$10-30 USD

Paid on delivery
Hey, I require 7 excel VBA Macro Scripts in total, but for now I only posted one to see if it works perfectly before doing the other 6. I require the following in the VBA script: (1) To first select the required data for which the functions will apply (2) Apply the functions by skipping rows i.e. Row 2 then apply this function to Row 11, 20, 29...etc. (SKIP BY 9 ROWS): Apply "Filter Data" to these rows and for Column "S"----Sort from "High to Low" After this function is done, I need a new row to be inserted above Row 5 and Row 7 (SKIP BY 9 ROWS) so this function should be applied to (Row 14,16) / (Row 23,25) / (Row 32,34)...etc------FINALLY, I want these rows to be colored black. PLEASE SEE VIDEO TO UNDERSTAND WHAT FUNCTIONS IM DOING, AND READ THE DESCRIPTION CAREFULLY
Project ID: 27396150

About the project

18 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
Awarded to:
User Avatar
Hello, I can help you with the macro, but please send me a message with the video because is not attached, it will help me to understand better the functionality of the macro. I can star working on it inmediately
$24 USD in 2 days
5.0 (41 reviews)
4.4
4.4
18 freelancers are bidding on average $28 USD for this job
User Avatar
Hi, Greetings! ✅checked your project details: Excel VBA Script (3 Functions) ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion.. Thank you Sandeep Digital screencast
$50 USD in 1 day
4.9 (479 reviews)
8.3
8.3
User Avatar
Hello, I am ready to discuss project with you. Being highly experienced in working on several complex Excel VBA Macro projects, based on that I can quickly help you in doing the task you need. Looking forward to have further project discussion on chat. Thanks. Vimal Arora
$30 USD in 2 days
4.8 (128 reviews)
6.1
6.1
User Avatar
Hi there, Gone through your requirements and clearly understood what you need. I am a Microsoft Certified Professional in Excel and VBA as an Expert. Awaiting your response to get started. Regards, Karthick G.
$30 USD in 3 days
5.0 (38 reviews)
5.1
5.1
User Avatar
Hi, I am Excel VBA expert having 7+ years of experience My works includes: 1. Project Dashboards, Employee tracker 2. Userforms, Automated calculations, pivots and graphs 3. Data consolidation using macro. 4. Share point and SQl connection from excel - Data retrieval and upload 5. Calendar creation 6. Import/Export data 7. Web scraping etc 9. Button creation on ribbon using xml My service includes: 1. Coding with proper comments for future use 2. Suggestions on improvement areas apart from client requests 3. First time configuration at right time Looking for positive response from you.
$20 USD in 2 days
5.0 (10 reviews)
4.4
4.4
User Avatar
Hi there! Hope you are doing well. I've already read your description and understood perfectly about your task. I had vast experience of Excel VBA(dashboard, pivot chart, automation), VB.net,... So i can provide high quality work as per your requirement. I am happy if you can explain me more detail about project on chat. Looking forward good response from you. Thanks for reading.
$50 USD in 1 day
5.0 (6 reviews)
4.1
4.1
User Avatar
Hi, I understood what you need. I can assist you in the best way & according to project requirement. I am an expert and professional in MS Excel & VBA. It includes extracting information from text files, websites, transferring info in to excel, User forms, 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 the creation of formulas using arrays, Pivot table creation, Creation of graphs, filtering, removing duplicates, Data analysis etc. You can see my profile before awarding me your project. “https://www.freelancer.com/u/yadavexpert53” Thanks, Mohit
$30 USD in 1 day
4.9 (30 reviews)
4.4
4.4
User Avatar
Hello. I'm a specialist in Excel and vba. I'd like to do all 7 macros, starting for this first that looks as an easy one.
$20 USD in 1 day
4.9 (10 reviews)
3.7
3.7
User Avatar
Hi, there is no video in the description. Please give me more details about your needs. Which calculations the function must do? If possible send the expected results in other sheet. WIth the rules above I can deliver in the same day. Thank you. Leopoldino
$30 USD in 1 day
5.0 (1 review)
1.5
1.5
User Avatar
I am a professional expert with 10 years of experience and knowledge in the technological area, if you give me the opportunity to participate in your project, you will not regret it.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I am a mechanical engineer and have vast experience on Excel and Macros. I am interested in this project as I have delivered the same kind of multiple projects in past. I am confident of delivering the quality work within time limits. I am working full-time and now want to start work as freelancer, looking for my first freelancer assignment. if you are interested in my profile, please let me know via chat.
$25 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have already done such scenarios for an Indian Bank named ICICI Bank Ltd. This was successfully completed.
$25 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi Hope you are doing well I can read the requirement and I can able to assist you on this project. Am having 6+ years of experience in Excel VBAAutomation. Am new to this platform...so am working for my review. Don't worry about the quality of the work we can deliver it at low prices Share the details... Hope you contact me soon Thanks in advance
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of RUSSIAN FEDERATION
Dubai, Russian Federation
5.0
1
Payment method verified
Member since Sep 6, 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.