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

• GOOGLE DRIVE LINK FOR MY PROJECT:

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

• Data summary of all male clients:

DSUM =	20318041019
DAVERAGE=	193396.4822

• Data Summary for all Flag Columns:

FLAG 2=DCOUNT()=307511

FLAG 3=DCOUNT()=307511

Other Deliveralbes:

• Macro and Freezing panes:

Sub JOE()
'
' JOE Macro
'

'
Range("C1").Select
With ActiveWindow
.SplitColumn = 0
.SplitRow = 1
End With
ActiveWindow.FreezePanes = True
ActiveWindow.SmallScroll Down:=-30
End Sub

• VBA Code to convert selected data into pdf from applicant data:

Sub joelll()
'
' joelll Macro
'

'
ChDir "C:\Users\new\Desktop"
ActiveWorkbook.SaveAs Filename:="C:\Users\new\Desktop\joel .mht", FileFormat _
;PDF\joel.pdf, CreateBackup:=False
End Sub

• Spelling mistakes in the workbook using VBA Code:

Sub Worksheet_Change()

If Application. CheckSpelling(Target.Value) = =False Then

Target.Font.Color = rgb(0,255,0)

Else

Target.Font.Color = RGB(0,0,255)

End Sub