Use Autofilter To Filter Your Data. Select a cell in the range. Say its code name is sht_calc.
Select the data you want to filter. Click the arrow in the column header and decide if you want to choose specific values or search. Please do the following steps to filter data using AutoFilter in Microsoft Excel.
Any cell will do but make sure you dont select more than one cell or.
AutoFilter is a simple lightweight jQuery live filter plugin that enables you to filter a collection of items such as products list items grid items by tags or input. You can get free access to this example workbook by clicking the button below. Click the arrow in the column header and decide if you want to choose specific values or search. For example suppose you want to quickly filter the data based on a drop-down selection and then copy this filtered data into a new worksheet.
