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

• Check Spelling mistakes in the workbook using VBA Code

Sub spellinghighlight()
Dim cell As Range
For Each cell In ActiveSheet.UsedRange
If Not Application.CheckSpelling(word:=cell.Text) Then
cell.Font.Color = vbRed
cell.Interior.Color = vbYellow
End If
Next cell
End Sub

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

Sub SaveActiveSheetsAsPDF() 'Create and assign variables Dim saveLocation As String saveLocation = "C:\Users\marks\OneDrive\Documents\myPDFFile.pdf" 'Save Active Sheet(s) as PDF ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _ Filename:=saveLocation End Sub

https://drive.google.com/file/d/1Kjij3ptEFpmdZZfR2d-4hEiWt1yX9jmD/view