From the course: Excel Copilot: Building and Maintaining VBA Macros

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Solution: Build polished report macros with VBA and Copilot

Solution: Build polished report macros with VBA and Copilot

From the course: Excel Copilot: Building and Maintaining VBA Macros

Start my 1-month free trial Buy for my team

Solution: Build polished report macros with VBA and Copilot

“

(upbeat music) - [Instructor] Let's tackle this report automation challenge using VBA macros with Copilot's assistance. Remember, how things turned out for you is almost guaranteed to be different than for me. So let's approach all solutions with curiosity and flexibility above all else. To start, we'll open the workbook named report-automation-challenge. First, let's use Copilot to create a macro that formats our sales data into a neat professional Excel table. Let's open up Copilot, App Skills. So here's our prompt, and again, these are all available in the solutions. Write a macro, we want it as a table, autofit and sort. So as we're getting these macros to run, sometimes you may see things, and this is something where getting into more detail with VBA and understanding the code will really help. So for example here it's saying take the range from A1 to D7. This is really a fixed range that will be converted…

Contents