Challenge

Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies

1) For Dashbord file please find below google link.

2) Seprate worksheet required for

Kindly find below attached file for this.

3) Create a Macro for Data Formatting (Conditional Formatting, Freezing Panes) of workbook as same will be applied to the data of next quarter

Kindly find below attached file for this.

4) Create VBA Code to convert selected data into pdf from applicant data

ActiveSheet.ExportAsFixedFormat _

Type:=xlTypePDF, _

Filename:="Sample Excel File Saved As PDF", _

Quality:=xlQualityStandard, _

IncludeDocProperties:=False, _

IgnorePrintAreas:=False, _

From:=1, _

To:=5, _

OpenAfterPublish:=True

5) Check Spelling Mistakes in the workbook using VBA Code.

Ship work like this
in your own course.