From the course: Excel Copilot: Building and Maintaining VBA Macros
Join today to access over 24,900 courses taught by industry experts.
Solution: Using prompts effectively for VBA
From the course: Excel Copilot: Building and Maintaining VBA Macros
Solution: Using prompts effectively for VBA
(upbeat instrumental music) - [Instructor] Welcome back. Let's dive straight into solving our Support Tickets Macro challenge. To begin, I'll make sure our customer support ticket data is stored as an Excel table, something clear and intuitive like customer tickets. So to insert the table, I'll do a Control + T here on my keyboard. You could actually put this as part of the macro, and we may do that in future videos. But for right now we'll set up the table on our own. I'll click okay after Control + T. And then the other thing I'll do here is right under table design is a place to name this. Like I said, giving these tables and columns really good names is going to help Copilot write more effective code and macro. So I'll call this something like customer_tickets and I'll hit enter to finish. Okay. So now let's tackle the issue of the hidden rows and columns. We will open up Copilot and our first…
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.