From the course: Excel Copilot: Building and Maintaining VBA Macros
Join today to access over 24,900 courses taught by industry experts.
Challenge: Automating data cleanup with VBA and Copilot
From the course: Excel Copilot: Building and Maintaining VBA Macros
Challenge: Automating data cleanup with VBA and Copilot
(bright upbeat music) - [Instructor] In this challenge, you'll solidify your VBA looping and conditional logic skills by tackling a realistic data cleanup scenario. Open the workbook data-cleanup-challenge, which contains employee time sheet data in a table called TimesheetData. Your objective is to automate the process of identifying and categorizing overtime hours, reinforcing the skills you've gained in this chapter. First, create a macro that ensures all rows and columns of the worksheet are visible. Your macro will then loop through each entry in the TimesheetData table, checking for unusually high working hours. Specifically, when an employee's hours worked exceeds 12 in a single entry, your macro will automatically flag that row by adding the phrase Overtime Review into a new column called ReviewStatus. Ensure that your macro adds this column neatly to the table complete with headers and autofit formatting,…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.