Excel VBA Macro: Autofilter (Based on Cell Value)

Excel VBA Macro: Autofilter (Based on Cell Value). In this video, we create a macro that filters data based on cell value. If you ever need to automatically filter data based on another cell in your workbook, with Excel VBA, you can use the code we write in this video to automatically filter data pertaining to a value in a cell that can be changed, without having to alter the code. The code specifies which worksheet it will be filtering, the starting point for the filtering, and then what cell will be used to filter by. The cell does not have to be on the same worksheet, and we can change the value of the cell as we please and filter by whatever we decide. After the filter is applied, only values that we want to see will be visible: giving you the freedom to change the value you filter by at will.

Data used in this video:
https://gsociology.icaap.org/dataupload.html

#ExcelVBA #ExcelMacro

Видео Excel VBA Macro: Autofilter (Based on Cell Value) канала greggowaffles