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

ans of dashbord and separate worksheet required sir accept the link i will write the ans given link .

https://docs.google.com/spreadsheets/d/1vzH7W4KI2HHW0YD0wIYjfYgXkh6GbpO0/edit?usp=share_link&ouid=107201079340888957708&rtpof=true&sd=true

other devarables.

1.first copy the macro code below onto the module in a workbook. this macro is also in the sample before usingit in your own excel files. the macro finds all the cells with conditional formatting and creates a text file with the details for each rule .

Sub CodFormatDocumenter()

'adapated from data valiadtion code posted by j.e mcgimpsy

'Excel condtional formatting

Dim sCF(0 TO 2 )AS Variant

Dim rCF AS Range

Dim rCELL AS range

Dim iCF AS Integer

Dim nFILE AS Long

Dim sC AS String

Dim strinteger color AS String

Dim strfontcolor AS string

End If

End Sub

2. ans

Sub SaveActiveSheetsASPDF()

' Create and assign variables

Dim SaveLocation AS String

savelocation=

'C:\USERS\MARKS\ONE DRIVE\DOCUMENTS\MYPDFFILE.PDF"

'Save Active sheet (s) as pdf

Active sheet. exportas fixedfo

rmat Type := x1 type pdf,-

filname;= location

End Sub

3. Sub SpellCheckInSpecificSheets()

worksheets("spell checking").spelling

worksheets(1). checksplling

End Sub