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

**MACRO FOR NEXT QUARTER IS SAVED AS "PROJECT2"**

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

Sub XL_t0_PDF()
ChDir "F:\"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:="F:\Applicant Data.pdf", _
Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
:=False, OpenAfterPublish:=True
End Sub

**SINCE MY LAPTOP IS WITH LOW PROCESSOR SO,ITS NOT RESPONDING BUT IF I TAKE SMALLER DATA THIS CODE WORKS**

VBA CODE FOR CHECKING SPELLING

Sub Highlight_Misspelled_Words()
Dim cell As Range
For Each cell In ActiveSheet.UsedRange
If Not Application.CheckSpelling(Word:=cell.Text) Then cell.Interior.ColorIndex = 6
Next
End Sub

Link:https://docs.google.com/spreadsheets/d/1B1dGWTuOsrj6EZ9mObVd2K9vg3Q8Z0uK/edit?usp=drivesdk&ouid=113003282060458258005&rtpof=true&sd=true