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

Project 2 -

Link of project 2 -

https://docs.google.com/spreadsheets/d/1X0BfWbfmnwqyVcok5_2kRLtwpQfLGsQ0/edit?usp=drive_link&ouid=113838243154655070062&rtpof=true&sd=true

• Check Spelling mistakes in the workbook using VBA Code -

Sub SpellCheck()

For Each sh In Worksheets

Sheets(sh.Name).Cells.CheckSpelling

Next

End Sub...

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

Sub SaveSelectionAsPDF()

'Create and assign variables

Dim saveLocation As String saveLocation = "C:\Users\marks\OneDrive\Documents\myPDFFile.pdf"

'Save selection as PDF

Selection.ExportAsFixedFormat Type:=xlTypePDF,

_ Filename:=saveLocation

End Sub

• Create a macro for conditional formatting & freezing panes

Public Sub FreezePanesAt(rngDataTopLeft As Range)
    Dim wndCurrent As Window
    
    For Each wndCurrent In rngDataTopLeft.Worksheet.Parent.Windows
        With wndCurrent
            .FreezePanes = False
            If Not ((rngDataTopLeft.Row = 1) And (rngDataTopLeft.Column = 1)) Then
                .ScrollRow = 1
                .ScrollColumn = 1
                .SplitRow = rngDataTopLeft.Row - 1
                .SplitColumn = rngDataTopLeft.Column - 1
                .FreezePanes = True
            End If
        End With
    Next
End Sub