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.

Automating report formatting with VBA and Copilot

Automating report formatting with VBA and Copilot

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

Start my 1-month free trial Buy for my team

Automating report formatting with VBA and Copilot

“

- [Instructor] Let's step through a common scenario for VBA, automating routine Excel reports. Despite all the advancements in web-based BI tools, there's still a ton of Excel based reporting happening via email spreadsheets. Maybe you're the one managing these reports and you want as much automation as possible to avoid mistakes and get your time back. This is exactly where copilot can help. Without further ado, open the exercise file called report formatting and let's get going. This is a typical sales extract that you might pull or have emailed to you weekly. Your task is to prepare it in a way that your coworkers can quickly understand and analyze. So here's what we want copilot to do. We'll convert the data set into a table named sales. We also want to format the unit price and total sales columns as currency, format the discount column as a percentage, and then apply conditional formatting to highlight any rows…

Contents