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

https://docs.google.com/spreadsheets/d/1-2nAlH_K4nGr2XVwpm5rC01kRYA0E44d/edit?usp=drive_link&ouid=115406054638963148777&rtpof=true&sd=true

Other Deliverables

• Create a macro for conditional formatting & freezing panes ?

Sub ConditionalFormattingExample()

‘Define Range
Dim MyRange As Range
Set MyRange = Range(“A1:A10”)

‘Delete Existing Conditional Formatting from Range
MyRange.FormatConditions.Delete

‘Apply Conditional Formatting
MyRange.FormatConditions.Add Type:=xlCellValue, Operator:=xlBetween, _
        Formula1:="=100", Formula2:="=150"
MyRange.FormatConditions(1).Interior.Color = RGB(255, 0, 0)
End Sub

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

Sub SaveActiveSheetsAsPDF()

'Create and assign variables

Dim saveLocation As String

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

'Save Active Sheet(s) as PDF

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _ 

    Filename:=saveLocation

End Sub

• Check Spelling mistakes in the workbook using VBA Code ?