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

https://drive.google.com/file/d/1HoWK1pjZA5fnPCk2qYEApgmDv8zZ5MJk/view?usp=sharing

Q.NO.1

• I have created dashboard by creating charts based on the given condition

Q.NO.2

• I have made pivot table for female clients
• By using DSUM function, I made a table for male clients
• By using DCOUNT function, I made a table for flag documents

Q.NO.3

• I have created macro name Data formatting and Record conditional formatting and freeze panes
• VBA code for convert excel file to pdf

  • Public Sub convert_pdf()
    Dim wb As Workbook
    Dim ws As Worksheet
    Dim rng As Range
    Dim path, filename As String

    Set wb = ThisWorkbook
    Set ws = wb.Worksheets("MALE CLIENTS")
    Set rng = ws.Range("A1:C50")
    path = "C:\Users\deepa\Documents\"
    filename = ws.Range("C1").Value & ".pdf"

    rng.ExportAsFixedFormat Type:=xlTypePDF, _
    filename:=path & filename, _
    IgnorePrintAreas:=True
    End Sub

• I have created VBA code to check spelling in the active worksheet
  • Public Sub Spellingmistake()
    Dim cell As Range
    For Each cell In ActiveSheet.UsedRange
    If Not Application.CheckSpelling(cell.Text) Then
    cell.Interior.Color = 255
    End If
    Next
    End Sub