From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Set up a macro for sorting dynamic data

Set up a macro for sorting dynamic data - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Set up a macro for sorting dynamic data

- [Instructor] We're looking at a list here, 2 an HR list, some 700 rows. 3 And let's say that I often need to sort this in four ways, 4 a four level sort. 5 And eventually what I'm going to be doing 6 is creating a button off to the right. 7 But my concern is this list will grow or shrink. 8 Let's first record a macro 9 and show what problem we might run into 10 regarding the location of the data. 11 We can begin recording a macro 12 by going to the View tab in the ribbon 13 and choosing the arrow underneath the Macros button 14 and choose Record Macro. 15 I'll give this a name, SortMacro for the moment. 16 Eventually if I have other macros, I'll expand this perhaps. 17 And I'll create a keystroke shortcut, 18 this is not a requirement, 19 but it makes it easy to test the macro. 20 So I'll use the shift key here. 21 I'm holding down the shift key as I press the letter M, 22 I want to store the macro in this workbook, 23…

Contents