Challenge

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

2.ANS :- SUMMARY FOR ALL FEMALE CLIENT FOR INCOME AND LOAN

=FILRR(sheet12!A1:C307512,B1,E6:E7) -FOR INCOME

=FILTER (sheet12!A1:C307512,C1,E6:E7) -FOR LOAN

3. ans :-VBA CODE FOR CHECK SPELLING MISTAKE

Sub HighlightMispellings()
Dim cell As Range
For Each cell In ActiveSheet.UsedRange
if Not Application.CheckSpelling( Word:- Cell.Text) Then

cell.style ="Bad"

End if

Next Cell

End Sub

3 . II .VBA CODE TO CONVERT SELECTED INTO PDF

Sub ExportToPDF()

Dim savePath As String

' Define the save path and file name

savePath = "C:\Path\To\Save\PDF\File.pdf" ' Update with your desired save path and file name

' Export the active sheet to PDF

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=savePath, Quality:=xlQualityStandard

' Display a message when the PDF is saved MsgBox "Worksheet has been exported to PDF."

End Sub

Ship work like this
in your own course.