Excel Automation into a particular format
₹600-1500 INR
Πληρώθηκε κατά την παράδοση
I need someone to develop a VBA/Macro code for me to automate certain activities on an excel sheet so that I can get the excel sheet in the proper format without manually entering formulas.
The functions to be automated are:
1. Deleting all rows other than RIC, Period, Release / Effective Date, Country, Prior, Median, Highest
Lowest, No. of Forecasts.
2. Adding formulas in Median (=Median), Highest (=Max), Lowest (=Min), No. of Forecasts (=count) for ranges in each column.
3. Deleting columns with less than 5 No. of Forecasts.
4. Detecting outliers across each column and highlighting them yellow.
5. Deleting contributors with no forecasts for any RIC.
6. Formatting Row 23 & 24 so that Organization/Question is on the same level as Sentix Index*, Employment Final QQ, Employment Final YY...
7. Median row should be font 12, bold & in orange.
8. Prior row should be font 10, bold, italics & in blue.
Ταυτότητα Εργασίας: #33154949
Σχετικά με την εργασία
Ανατέθηκε στον:
Senior Excel vba Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from t Περισσότερα