Completed

VBA Macro to filter, sort and mark results

I need a VBA macro that loops through every single industry in a list and for every industry does the following:

Take the subtotals

1. Sorts the industry entries per sales growth and Highlights the top highest 5 entries in green and the lowest 5 in red. If the filtered results are less than 10 then highlight top half results in green and bottom half results in red.

2. Then for the same industry sort the entries per earnings growth F1 and highlights the highest 5 in green and lowest 5 in 5 red

3. So the same for F2

4. Extract the entries that have all 3 categories in green and all 3 categories in red in a separate sheet

Once done proceed to the next filter entry.

See attached file for description.

The macro needs to be well written and commented and needs to work for large files with many different industries

N.B. To make sure you have read and understood the description I will only consider offers starting with the code word "Carrot".

Skills: Data Entry, Data Processing, Excel, Statistics, Visual Basic

See more: excel vba advanced filter multiple criteria, vba filter, how to filter data in excel using macro, vba code to filter data in excel, excel vba filter function, excel vba filter multiple criteria, excel vba filter multiple criteria different column, excel vba filter table by column name, vba macro excel unicode, excel vba macro paste adjacent column, next empty cell vba macro paste, vba macro trial, vba macro generate report excel word, paste excel vba macro, row column increment vba macro, vba macro click button webpage, excel vba macro databases, calling oracle procedure vba macro, vba macro perl, access filter sort vba

About the Employer:
( 4 reviews ) Haarlem, Germany

Project ID: #18855869

Awarded to:

Capitan0Trueno

Carrot. MS Office / MS Excel advanced expert. 30 years experience in MS Excel and VBA programming. Web scraping, office automation, management dashboards, data mining and analysis, Montecarlo simulation, discrete even More

$25 USD in 2 days
(33 Reviews)
4.7

37 freelancers are bidding on average $30 for this job

schoudhary1553

carrot 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 More

$50 USD in 1 day
(329 Reviews)
7.8
bouslimi1979

"Carrot". All is clear. Have 2 questions : 1) do you want a feature where you will select the file to proceed, or you will copy past the data manually ? 2). In your explanation why the data was not sorted by industry More

$50 USD in 1 day
(284 Reviews)
7.6
TonmoyRoy111

CARROT Dear client I have read the attched word file containing the description. I will write the macro code for you within some hours. Please contact me and share the file. Roy

$30 USD in 1 day
(303 Reviews)
6.7
ksriniravi

Carrot Greetings! I presume that for the first requirement (Take the subtotals ) you might consider adding a statement that Industry wide sub totals need to be captured in a separate sheet. All requirements ar More

$30 USD in 1 day
(171 Reviews)
6.7
VladimirLilenko

Carrot Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest More

$30 USD in 1 day
(86 Reviews)
5.9
helalru

Dear sir, I have read your project details and understand.I am a responsible and dynamic person with a strong sense of commitment; giving the best of my skills and experience to get the job done. here I am running a t More

$10 USD in 1 day
(40 Reviews)
5.5
aubrey03

Carrot I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] More

$30 USD in 1 day
(84 Reviews)
5.5
urielbaray

Hi! Thank you for taking the time to read my proposal, My name is Uriel Baray I am a VBA Excel Expert with several years of experience on the field, if you are so kind to take a look to my portfolio, I have some sam More

$25 USD in 1 day
(23 Reviews)
4.7
Mokshith30

Hi I have Read Your Requirements I am Excel VBA Expert Experianced in VBA Macros & Web Scraping Script... I can finish any kind of vba task in 1 day only pls see my previous projects for my vba experiance T More

$25 USD in 0 days
(29 Reviews)
4.1
nvchien94

Hello there, I am an Excel freelancer and I can help you to solve this task. With 4 years + in data processing adn VBA, it's not hard project and can be completed in 5 hours. Please contact me and send me your ex More

$25 USD in 1 day
(35 Reviews)
4.2
webanis

Hi, I am interested in your offer: Excel VBA code. Let me know more details about this work. I will start working immediately :) Br;

$25 USD in 1 day
(21 Reviews)
4.1
valor312

How are you? I have many experiance in Excel/Access/VBA/FormDesign/Marco. I have done many project by using ActiveX Form control and vba, query in excel and access. And I have high technology such as Data Mini More

$25 USD in 1 day
(5 Reviews)
3.4
gsanggara

"Carrot" Hello Kalorifera, I interested to your project. I can create excel VBA to do looping through every single industry in a list and do all the task mentioned in your DOC attachment file. Please message m More

$25 USD in 0 days
(20 Reviews)
3.7
KozlouAlex

Carrot. I have done very similar VBA project recently: https://www.freelancer.com/projects/data-entry/vba-excel-compare-count-sort/?w=f I can complete this task today.

$25 USD in 0 days
(8 Reviews)
3.5
arash18k

Hi, first your requested word "Carrot". I can develop such VBA for you in less than 2 days which will work for you in very large data

$30 USD in 2 days
(2 Reviews)
2.3
ielucerotrad1

Carrot! I can do the job. To work with large files, I design my code base on arrays and not excel object, so it will work extremely fast. Have used this approach in large signal processing files with over 700.000 rows More

$30 USD in 3 days
(3 Reviews)
1.7
STdevil22

hi,i am new worker,but i have expert this [login to view URL] you give me one chance,i will proof my [login to view URL] message me.i will start your work now

$20 USD in 0 days
(1 Review)
1.4
xlmomtaz

"Carrot" Hi, I've checked your word document and images therein. Excellent descriptions! I will write a VBA macro inside the Excel file. No problem that the file is a large one and there are so many industries. More

$25 USD in 2 days
(0 Reviews)
0.0
Mkaradas

Carrot Hello I have been developing Access and Excel VBA based systems for 15 years. I can guarantee that you will be satisfied with the result. Hope that you will give me a chance to show you how good we will c More

$25 USD in 1 day
(0 Reviews)
0.0
mushtari

I am an expert and communicate well. Relevant Skills and Experience Vba vb.net

$111 USD in 3 days
(0 Reviews)
0.0