Excel Automation into a particular format
Budget: ₹600 – ₹1,500 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.
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.