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

link for answers

https://drive.google.com/drive/folders/1Ch3AFhxMYMHGJ9jbBlD7OcydQs6fLc1j?usp=share_link

• Macro for formating, find below screenshots

• Check Spelling mistakes in the workbook using VBA Code

Sub highlight_mistake()

Dm cl As range

Activesheet.usedRange.interior.Color = xlNone

For Each cl In Active.sheet.UsedRange

If Not Application.CheckSpelling(word: = cl.text) then

cl.Interior.Color = vbRed

End If

Next cl

End sub