During my Business Analytics class, I was introduced to Visual Basic for Applications (VBA), the programming language behind Microsoft Excel. I had the opportunity to dive deeper into VBA during one of my internships. I spent the summer of 2021 working in VBA and designing a series of macros to create a data quality scorecard. One of the key advantages of macros is automating repetitive processes. Before sending out product data to any distributors or publishing it on eCommerce sites, the data undergoes a detailed check to ensure that nothing is missing. Before the scorecard was created, this process was done SKU by SKU by one of our data stewards. Now, the scorecard performs all of the checks, and the data stewards can focus on filling in the identified gaps. The input for the scorecard is a data extract from our Product Information Management (PIM) system. The scorecard runs the macros to test the data against forty requirements. Then, it creates a summary table to display the percentage of SKUs that passed for each rule with links to individual tabs. On those tabs, data stewards can view the SKUs that failed to quickly see which SKUs are missing data in that field. The scorecard has significantly reduced the time spent on finding missing data, so the data stewards are free for other tasks. It also helps prevent the human errors that arise from manually checking data to ensure we are not sending incomplete or incorrect datasets to our distributors.