Join Dennis Taylor for an in-depth discussion in this video Set up a macro for sorting dynamic data, part of Excel Tips Weekly.
- [Voiceover] We're looking at a list here.…An HR list, some 700 rows.…And let's say that I often need to sort this four ways,…a four level sort.…And eventually what I'm going to be doing…is creating a button off to the right.…My concern is,…this list will grow or shrink.…Let's first record a macro and show…what problem we might run into…regarding the location of the data.…We can begin recording a macro…by going to the view tab in the ribbon…and choosing the arrow underneath the macros button,…and choose record macro.…
I'll give this a name,…sort macro, for the moment.…Eventually if I have other macros,…I'll expand this, perhaps.…And I'll create a key stroke short cut.…This is not a requirement,…but it makes it easy to test the macro.…So I'll use the shift key here.…I'm holding down the shift key as I press the letter M.…I want to store the macro in this workbook.…I'll get to the description later.…So as I click OK, I'll be in record mode.…And because some of the people who might be using…this sort macro later…may not be too familiar with Excel,…
Skill Level Appropriate for all
Excel Tips - New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.