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/1hQw1AajEmb_f3V4n3w7pdhx8TYBGw5gC/view?usp=share_link
Q3.
- Create a Macro for Data Formatting (Conditional Formatting, Freezing Panes) of workbook as same will be applied to the data of next quarter
To view the macro
View>Macros>View Macros
- 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\Skill-Lync\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
Sub Highlight_Misspelled_Words()
Dim cell as Range
For Each cell In ActiveSheet.UsedRange
If Not Application.CheckSpelling(Word:=cell.Text) Then cell.Interior.ColorIndex = 6
Next
End Sub