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/1sMUOvfqapAtMH5hN10fWOn3cwUlWPRgB/edit?usp=sharing&ouid=114658586470195318383&rtpof=true&sd=true

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

Sub ExportSelectionToPDF()

Dim myRange As Range
Set myRange = Selection

Dim PDFFileName As String
PDFFileName = "Applicant_Data_" & Format(Date, "yyyymmdd") & ".pdf"

myRange.ExportAsFixedFormat Type:=xlTypePDF, Filename:=PDFFileName, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=True

End Sub

* Spelling mistakes in the workbook using VBA Code

Sub CheckSpelling()

Dim ws As Worksheet
For Each ws In ThisWorkbook.Sheets
ws.Activate
With ws.Range("A1:Z1000") 'change the range to the desired size
.CheckSpelling SpellLang:=1033
End With
Next ws

End Sub

https://docs.google.com/spreadsheets/d/1sMUOvfqapAtMH5hN10fWOn3cwUlWPRgB/edit?usp=sharing&ouid=114658586470195318383&rtpof=true&sd=true