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

https://drive.google.com/file/d/1JhqzKrFrAYPdNn_qsMtAysjpx8Xt6yYL/view?usp=share_link

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

• Check Spelling mistakes in the workbook using VBA Code

Public Sub SpellError()
Dim rng As Range
For Each rng In ActiveSheet.UsedRange
If Not Application.CheckSpelling(rng.Text) Then
rng.Interior.ColorIndex = 3
End If
Next rng
End Sub