How to implement automatic filtering in excel in VBA

About advanced filtering, not much to say, excel comes with, data-filtering-advanced filtering, add a point to note, when filtering, you should check "select not to repeat records", the other is that excel may automatically expand the scope of filtering, for example, the number is also 001, but the number is different, at this time excel will think that these are two different records and thus both are displayed, but we may only need to know different numbers, regardless of the number. The solution is to separate the numbered column from the other columns with an empty column, then select the column and then use the advanced filtering feature.

The meaning of your title is that you want to refill the data selected by the advanced filter into another table, right? If you don't want to use it often, you can directly select it and copy and paste, if you want to use it often, you can use macros, the following is what I got with the recording macro in excel2003, and copy the filtered data in Table 1 to Table 2. You can see that it needs to be changed.

sub macro1()

macro1 macro

range(selection,range(selection,sheets("sheet2").selectpaste:=xlpastevalues, operation:=xlnone, skipblanks _

false, transpose:=falseend sub

Hope it helps.

Excel has a deduplication function.

This is a de-re-recorded VBA**.

c$1:$c$4").removeduplicates columns:=1, header:=xlno

1. Automatic filtering: Open the **excel file that needs to be filtered, click on the cell with the mouse to locate any cell area containing data, and click the menu bar - data - filter - automatic filter.

2. Drop-down arrow: After selecting automatic filtering, the drop-down arrow appears in the data column, and click the drop-down arrow to display the filter menu. Each drop-down menu corresponds to a filter category.

3. Filtering method: Click on the number filter to filter the data for a specific data or a certain numerical interval for the ** file containing a large amount of data. For example, if you need to filter out items with a historical score of less than 85 points, click on the number to filter, select less than, and enter 85 to filter.

4. Establish a region: If you want to filter out the scores of multiple categories, such as students with scores greater than 80 points in four subjects, you need to establish a conditional area in advance, and empty three or more rows above the overall data, corresponding to the input data classification and the required condition restrictions.

5. Advanced filtering: Click the menu bar - Data - Filter - Advanced Filter to open the menu of advanced filtering.

6. List area and condition area: After opening the advanced filter, you can enter the cell range or use the mouse to check the required area, and check the list area and the condition area respectively.

7. Result acquisition: If you need to let the filtered data be displayed elsewhere alone, check the box to copy the filtered results to other locations, and manually click the cells that need to be stored.

Click OK to get the filter results.

The steps to filter some data in VBA are as follows:

1. We open the excel software, select a region, and then we need to filter the data of one of the classes.

2. Next, let's enter the VBA area, let's first take a look at how to select the area of a certain row.

3. In addition, we can also select rows and columns through entirecolumn and entirerow.

4. After understanding the above two usages, we can select the area specified at the beginning through range.

5. Next, we can traverse through the foreach loop to select the area and find the content of the banquet we need.

6. Finally, run the VBA program, we can see that the data of the first class are filtered out.

Excel automatic filtering is a very easy function to operate, but also a data ** often used operations, let me bring you Excel2007 automatic filtering method.

The steps of excel2007 automatic screening are as follows:

Step 1 Click any cell in the Select Data range, then click the Data function option, and then click the Filter tool button in the Sort and Filter function group, as shown in Figure 2. Figure 1, Figure 2

Step 2 Click the filter button to the right of the Job Title field, and then click the Select All checkbox from the drop-down list. Figure 3, Figure 4

When you click the Filter button in the ribbon, a Filter control button automatically appears to the right of each field. As you can see from the worksheet shown in Figure 4, the filter button on the right side has changed after carefully filtering the data in the "Job Title" column, so you can see which columns are filtered from the filter button, that is, which columns are set with conditions. In addition, you can also see which rows are hidden from the worksheet row number.

After the single-condition automatic filter in Excel2007 filters the data**, the row numbers of the currently displayed data rows are blue, and the filter information is displayed on the window status bar.

1.excel2007 sets the method of multi-row automatic filtering.

2.Excel2007 Auto Filtering Tutorial.

3.How excel uses auto-filter tools to filter data.

There are many kinds of data in Excel, when we just want to pick the data we need, it is a bit time-consuming and laborious to view them one by one, so we can use Excel's "automatic filtering" tool to view and select the data you need conveniently and quickly. I'll teach you how to use Excel's auto-filtering smartly.

Clever use of Excel's auto-filtering methodMethod.

1. Directly select the filter object

1.Open Excel** and select the "Data" - "Filter" - "Autofilter" command in the menu bar. Here we take the screening of "gender female" as an example.

Figure 1 of the automatic screening method using excel2.An inverted triangle button appears in the bottom right corner of the first row of cells. Click the category you want to filter and select the object to be filtered.

Figure 2 of the automatic screening method using excelMethod.

2. Select the filter object through "Custom".

1.We select the cell named "Gender", click the drop-down triangle button in the lower right corner of the cell, and select the "Custom" command in the pop-up drop-down box.

Figure 3 of the method of automatic screening using excel2.In the Customize Auto Filter Method dialog box, select the Include option in the bar box under Gender, select Female in the bar box on the right, or enter Female by yourself, and click OK to complete the filter.

Figure 4 of the automatic screening method using excel

You may also like: 1How to use the auto-filter function in Excel.

2.How to use Excel2010 auto-filter.

3.How does excel make hidden rows no longer appear when auto-filtering?

4.Filter function in Excel using method steps.

5.How to use multi-criteria filtering in Excel2013.

6.How to use advanced filtering in Excel.

1. First of all, open Excel, open the corresponding grade table, select any unit bar in the data table, and execute the "Data Filtering Auto Filter" command to enter the "Auto Filter" state.

2. Select cell D1 (i.e., the cell where the title field of "Language" is located), press the drop-down button on the right side of it, and select the "Custom" option in the shortcut menu that pops up later.

3. At this time, the system pops up the "Customize automatic filtering method" dialog box, click the drop-down button in the left box, select the "less than" option in the drop-down list that pops up, and then enter the value 60 in the back box to confirm the return.

4. Follow the above operation, further set the filter conditions of "mathematics", and after confirmation, the required data will be filtered out immediately.

5. Select the filtered data area, execute the "Positioning" command, open the "Positioning" dialog box, press the "Positioning" button to open the "Positioning" dialog box, select the "Visible Cells" option, and confirm the return.

6. Perform the "copy" stool operation, then switch to the sheet2 worksheet, select the first cell of the save area (such as A1), and perform the "paste" operation on Zaoyan.