From the course: Excel: Macros in Depth (Microsoft 365)
Unlock the full course today
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
Recording partial code
From the course: Excel: Macros in Depth (Microsoft 365)
Recording partial code
- [Instructor] In this workbook called Partial, we've got a worksheet called Colorado. It's 2400 rows. 400 different realtors. And we'd like to get this information in a more usable Excel layout by having all the people's names in column D, the company names in column E, the business addresses in column F, and so on and so on. And the way we're going to be doing this will reveal some different aspects of Excel. It might not be the most efficient way, but it will reveal some ways of working with Excel that you might not have seen. And one technique we're going to be using, too, is a split-screen technique that will allow us to see the Visual Basic code as it is being created. Now, let's set this up first by creating an empty macro. We'll go to the Developer tab, choose Record Macro. An empty macro, we don't care what the name is, cause we're going to be deleting it. Click OK. And then stop recording. We can get…
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.