Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies
Please find attached the link for the dashboard below.
https://drive.google.com/file/d/1TPHL1Si3yeNbIGgIgywy8fLUSGabA314/view?usp=sharing
And other deliverable as VBA code is not working in the system.
Create VBA Code to convert selected data into pdf from applicant data
Sub ExportToPDF()
Sheets("YourSheetName").Select ' Select the sheet containing your data
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:="Path\to\your\output.pdf"
End Sub
Check Spelling mistakes in the workbook using VBA Code
Sub SpellCheckWorkbook()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
ws.CheckSpelling
Next ws
End Sub