Excel VBA Bangla Tutorial 52 : Advanced Filter - Filter any Excel data | Database Bangla tutorial

Описание: Please download your working file from below link
https://drive.google.com/file/d/1z1el...

Advanced Filter is an Excel feature that allows you to filter a range of data based on specific criteria. It provides more flexibility than the basic filter option, and can be used to filter data in place, or to copy the filtered data to a new location.

To use Advanced Filter in Excel, you need to follow these steps:

Ensure that your data has column headings, and that it is arranged in a tabular format.
Create a criteria range that specifies the conditions for the filter. This range should have the same column headings as the data range, and the criteria should be entered in the rows below the headings. You can use logical operators such as AND, OR, and NOT, and wildcards such as * and ? to define your criteria.
Select the range of data that you want to filter.
Open the Advanced Filter dialog box by going to the Data tab and selecting the Advanced button under the Sort & Filter group.
In the Advanced Filter dialog box, select the "Filter the list, in place" option to filter the data in place, or select the "Copy to another location" option to copy the filtered data to a new location.
In the "List range" field, enter the range of data that you want to filter.
In the "Criteria range" field, enter the range of criteria that you created in step 2.
If you selected the "Copy to another location" option, enter the destination range where you want to copy the filtered data.
Click the OK button to apply the filter.
Advanced Filter can be particularly useful when working with large amounts of data, or when you need to perform complex filtering operations. In Excel VBA, you can automate the process of creating and applying an advanced filter by writing a macro that defines the data range, criteria range, and other filter options. You can also use Excel VBA to work with databases in Excel, such as by connecting to an external data source or creating a data model.