Module 2 VBA Challenge
Attached is the .vbs document that contains my VBA script for the Module 2 VBA Challenge. I've also included three screenshots of my results, one for each sheet. Each screenshot has been named as the year for which each sheet is dated.
Sources:
#VBA Loop through all Worksheets https://www.youtube.com/watch?v=AlC8a7KyJq0
#Using Conditional Formatting with Excel VBA https://www.automateexcel.com/vba/conditional-formatting/
#Data type summary (for VBA) https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/data-type-summary
#How to select cells/ranges by using Visual Basic procedures in Excel https://learn.microsoft.com/en-us/previous-versions/office/troubleshoot/office-developer/select-cells-rangs-with-visual-basic
#VBA - If Statement https://www.tutorialspoint.com/vba/vba_if_statement.htm#:~:text=An%20If%20statement%20consists%20of,the%20If%20loop%20are%20executed.
#Find the row/column reference of a variable containing a calculated maximum value https://stackoverflow.com/questions/62544222/find-the-row-column-reference-of-a-variable-containing-a-calculated-maximum-value
#Finding max value of a loop with VBA https://stackoverflow.com/questions/45072650/finding-max-value-of-a-loop-with-vba
#How to Find Last Row, Column, and Cell using VBA in Excel https://excelchamps.com/vba/find-last-row-column-cell/
#Excel / VBA - How to select the top row (absolute) of whichever column (relative) the currently selected cell is in? https://stackoverflow.com/questions/50247228/excel-vba-how-to-select-the-top-row-absolute-of-whichever-column-relative
#Range.RemoveDuplicates method (Excel) https://learn.microsoft.com/en-us/office/vba/api/excel.range.removeduplicates
#VBA Copy Paste Distinct Values Only Leave Blanks and Sort Ascending https://www.mrexcel.com/board/threads/vba-copy-paste-distinct-values-only-leave-blanks-and-sort-ascending.1109623/
#How to Calculate Percent Difference Between Two Numbers in Excel https://www.youtube.com/watch?v=eJLBTIygR4I
#How to Calculate Year-Over-Year Growth https://www.sisense.com/blog/calculate-year-year-growth/
#How to use the IF-THEN-ELSE Statement (VBA) https://www.techonthenet.com/excel/formulas/if_then.php
#Range.Autofit Method (Excel) https://learn.microsoft.com/en-us/office/vba/api/excel.range.autofit
#VBA Paste https://www.wallstreetmojo.com/vba-paste/
Studied with both classmates: Shelonta Gilbert and Max Cintra