Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies
2.1.Data Summary of All Female Client’s for Income and Loan Amount using New Functions

3.1.


3.3.Check Spelling mistakes in the workbook using VBA Code
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
Tried to run this code but my excel 2013 is not responding because its a huge data so hence writing the code here
Drive Link :
https://docs.google.com/spreadsheets/d/13_3y7AvwIh3Xoum1c5g5Vd1gBHr7Op0s/edit?usp=share_link&ouid=104408424478197221785&rtpof=true&sd=true