Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies
- Create a macro for conditional formatting & freezing panes
Click on the cell that contains the conditional formatting rules, and in the Menu, go to Edit > Copy. Highlight the cells where you want the formatting to be copied to, and then in the Menu, go to Edit > Paste Special > Paste conditional formatting only.
* Create VBA Code to convert selected data into pdf from applicant data
- Select the worksheet(s) that you want to export as PDF.
- Next, on the Excel Ribbon, click the View tab.
- At the right end of the tab, click Macros.
- In the list of macros, select the PDF Export macro that you want to run.
- Click the Run button.
- The macro runs, and exports the sheet(s) to a PDF file.
* Check Spelling mistakes in the workbook using VBA Code
- Launch Spellcheck from VBA. The syntax to launch the Spelling dialog box using the default settings: sheet1. ...
- Spell Check Before Closing Workbook (VBA BeforeClose) ...
- Highlight Misspelled Words with a VBA Macro.