From the course: Excel Copilot: Building and Maintaining VBA Macros
Join today to access over 24,900 courses taught by industry experts.
Solution: Automating data cleanup with VBA and Copilot
From the course: Excel Copilot: Building and Maintaining VBA Macros
Solution: Automating data cleanup with VBA and Copilot
(upbeat music) - [Instructor] Let's walk through how I approach this challenge. Open the file data-cleanup-challenge to follow along. First, here's the prompt I use to unhide rows and columns and flag overtime entries. I'll start up Copilot here. And again, from the solution files, we can get the prompt. Okay, so we have a macro, we're going to unhide. We are also going to set up Overtime Review based on hours worked exceeding 12 here. So I'll run this and we will get our first pass at this macro. And we will get a macro here. Now again, this may look quite different than yours and one thing that you could do if you wanted to dig in on this code is maybe show your macro and the solution file macro to Copilot, and understand those similarities and differences, asking Copilot for help there. But we're going to go ahead and take this macro that I got here and expand the interactivity with the next prompt. So what we'll do…
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.