Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies
- Create a Macro for Data Formatting (Conditional Formatting, Freezing Panes) of workbook as same will be applied to the data of next quarter
- Create VBA Code to convert selected data into pdf from applicant data
- Check Spelling mistakes in the workbook using VBA Code
EXCEPT FOR THESE 3 QUESTIONS A SMALL SET OF DATA IS COPIED FROM MAIN DATA AND DONE
FOR FIRST THREE QUESTIONS FULL DATA IS CALCULATED ACCORDING TO THE QUESTIONS
HOPE EVERYTHING IS CORRECT IF ANY MISTAKES PLEASE MENTION IN REMARKS