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

Excel file link

https://docs.google.com/spreadsheets/d/1-ZCDAOT6f2dP4XWGuZjbd2XD_t191nTq/edit?usp=drive_link&ouid=107149231386564051483&rtpof=true&sd=true

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

Sub SaveAsPDF()

Dim WS As Worksheet

Dim FileName As String
Dim FilePath As String

Set WS = ActiveSheet

FileName = "Result PDF"

WS.PageSetup.Orientation = xlPortrait

FilePath = ThisWorkbook.Path

WS.ExportAsFixedFormat Type:=xlTypePDF, FileName:=FilePath & "\" & FileName & ".pdf", _ Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False

MsgBox "Completed", vbInformation, ""

End Sub

Check Spelling mistakes in the workbook using VBA Code

Dim rng As Range
For Each rng In ActiveSheet.UsedRange
If Not Application.CheckSpelling(rng.Text) Then
rng.Interior.Color = 6
End If
Next rng