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

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

Sub ConvertDataToPDF()
Dim rng As Range

Set rng = Selection

rng.Copy
Sheets.Add After:=Sheets(Sheets.Count)
ActiveSheet.Paste

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:="C:\Path\to\output.pdf", Quality:=xlQualityStandard

Application.DisplayAlerts = False
ActiveSheet.Delete
Application.DisplayAlerts = True

MsgBox "Data has been converted to PDF."
End Sub

• Q)Check Spelling mistakes in the workbook using VBA Code

Sub CheckSpellingMistakes()
Cells.CheckSpelling
End Sub