Skip to content

How to get advanced filter to update dynamically in excel

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to get advanced filter to update dynamically in excel

55,883 views October 26, 2019 5:27

Watch on YouTube

ChannelKarina Adcock

Description from the creator

Use advanced filter while recording a macro. Assign the macro a keyboard shortcut. Then save the excel workbook as a macro enabled workbook. Then you can use the keyboard shortcut to run the macro and get advanced filter to automatically update when you change the filter criteria to investigate your data.
--------------------------------------------------------------------------------
#exceltips #exceltutorials #msexcel

SUBSCRIBE: goo.gl/c46YPs

Microsoft Office 365, 2016, Office Insider, Version 1908
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:
- How to use advanced filter to remove blanks in excel youtu.be/inC2jMxm5eE
- How to filter in excel - 5 different methods youtu.be/69c0cJhRmFM
- How to filter using vlookup in excel youtu.be/or6vcScX6mM

About this tutorial

Karina Adcock published this 5:27 video tutorial on October 26, 2019. It has been watched 55,883 times on YouTube.

Channel: Karina Adcock
Category: Science & Technology
Duration: 5:27
Published: October 26, 2019
Views: 55,883
Likes: 284

Tags

Share

Further reading

How To Auto-Refresh Filtered Data In Excel When It Is Updated addictivetips.com
The filter extends to and applies to data values in the corresponding rows as well. What the filter doesn’t do is auto-update itself. If a value in a filtered column changes, either because you manually updated it or a…
How to filter data from one worksheet to another dynamically ... extendoffice.com
Filter data from one worksheet to another dynamically in Excel. To finish this task, please do with the following step by step: 1. First, define a range name for the source data, please select the data range that you wa…
How to update advanced filter result automatically in Excel? extendoffice.com
The following VBA code may help you to automatically update the advanced filter result when you change the criteria as you need, please do as this: 1 . Right click the sheet tab that you want to filter the data automati…

This tutorial in other languages

Web Analytics