Challenge

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

Your portfolio, next

Ship work like this
in your own course.

Talk to a career counsellor

Free 20-minute call. We'll map the right course to where you want to work.

By submitting you agree to our Terms and Privacy Policy.