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

my laptop is old version ,newfuntion,list funtion not available

Respected mam,

i have done all question but the data is to large so i m not able to convert into google sheet.pls take this photo as answer.

[separate worksheet requried for]

other deliverables

Sub colorMispelledcells()

Dim cl As Range
ActiveSheet.UsedRange.Interior.Color = xlNone
For Each cl In ActiveSheet.UsedRange
If Not Application.CheckSpelling(word:=cl.Text) Then
cl.Interior.Color = vbRed
End If
Next cl
End Sub

vba code for convert PDF

Sub saveactivesheetsASpdf()
'create and assingn variables
Dim savelocation As String
savelocation = "C\Users\marks\onedrie\documents\mypdffile.pdf"
'save active sheet(s) as PDF
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=savelocation
End Sub