Excel can be on the table a number of automatic filter you

Excel would like to sheet1 of the two tables sheet2 and data filtering, the two fields are the same table.

Yes, you have chosen to filter the data, and then in the form toolbar options, select the automatic selection.Your choice of data, the first line of cells in the column will appear Toolbar, according to the requirements of your operations on the OK.If you have focused on screening, you can choose to “data” and then click on the “screening” “Automatic selection”; If you want to filter the content more, more complicated, you can choose to “data” and click on the “screening” of “high-level screening”, and then in the dialog box that appears, in accordance with the requirements, you have to fill in Screening of the contents of the can.You can first try to see if it is not the kind you want the results.The best use of multiple data PivotTable feature, as long as you two by your SHEET difference in the requirements of Screening will be able to choose the.