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".
37 pekerja bebas membida secara purata $30 untuk pekerjaan ini
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
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.
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