Collection of Excel VBA scripts/macros
MMAutoFillDeptCol -> dynamic data sorter that auto detects sorting logic based on user input and different criterias regarding the records, transformed a 2h-3h process into less than 10 seconds
MechProcessExceptionList -> uses a list of exceptions previously pasted in Sheet 2 and finds the corresponding records on Sheet 1. Makes it easier to find and make all necessary changes to records causing the exceptions can be made directly (usesul for big files of 1,000+ records)
QcAutoHighlight -> macro that checks the data in 2 different sheets and highlights all differences on Sheet 1 and adds a "U" in column 2 of the corresponding rows, indicating an update
ShortcutHighlight -> small macro to use as a shortcut for yellow highlighting in Excel