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

Drive LINK:

https://docs.google.com/spreadsheets/d/1D1ZPl9qzsryFLB8wsXIE46TjwR3Ar6E9/edit?usp=share_link&ouid=108180774161908687435&rtpof=true&sd=true

• Create a Macro for Data Formatting (Conditional Formatting, Freezing Panes) of workbook as same will be applied tothe data of next quarter

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

• Check Spelling mistakes in the workbook using VBA Code

Public Sub SpellCheck()

Dim Rng As Range

For Each Rng In ActiveSheet.UsedRange

If Not Application.CheckSpelling(Rng.Text) Then

Rng.Interior.Color = RGB(255,0,0)

End If

Next Rng

End Sub

Note: I have a older version of Excel So here im writing the code