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

vba code below, to convert selected data into pdf from applicant data :

Sub SaveRangeAsPDF()

Dim saveLocation As String
Dim ws As Worksheet
Dim rng As Range

saveLocation = "C:\Users\ADMIN\Documents"
Set ws = Sheets("Sheet1")
Set rng = ws.Range("A1:H20")

rng.ExportAsFixedFormat Type:=xlTypePDF, _
Filename:=saveLocation

End Sub

other answers in mega app link below;

https://mega.nz/folder/Kl4nVRjA#ic6zfMqDzNJNtDKDbQ74dw

1. applicant data pivot.csv(1) contains features of dashboard.

2. applicant data file contains data summary of male in sheet1 ,in sheet 2- flag columns, in applicant data sheet i created macro as per given question.

3. i have attached screenshot png for data summary of female clients using sort funtion.

for last question i dont know vba code. because error is showing still not executed.