Challenge

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

https://drive.google.com/drive/folders/1zSQNwWigPSdWpl5WagRkCXILZU11fWd3?usp=share_link

*Please go through the files which are Q1 Dashboard, Question 2, Question 3 If Q1 Dashboard shows errors please go through the Book1 excel*

The VBA code are

Sub SaveSelectionAsPDF()

Dim savelocation As string

savelocation = "C:\Users\sairam\Dcouments\myPDFFile.PDF"

Selection.ExportAsFixedFormat Type:=xlTypePDF, _

Filename := savelocation

END Sub

Sub misplled_word()

Dim c As Range

For Each c In ActiveSheet.UsedRange

IF Not Application.CheckSpelling(Word:=c.Text) Then c.Interior.ColorIndex = 45

End Sub

Ship work like this
in your own course.