Before you begin, a sample Excel document can be downloaded from https://zscoffice1.sinaapp.com/Information%20Filter/sample
The sample file we provided illustrates a table of products. Product's attributes are stored in columns wise. For example, Col A is ID of products, Col B is name, and Col C is price. Each row stands for a single product.
This app will focus on the information you interest in. For example, you want to inquire the product name, price and manufacturing date only.
-Click "Start to Select" button
-Select a region you interest in. Click left-upper corner of the region first and then the right-down. For example, firstly we
choose row 1 col A, then row 20 col I.
-Select the type to display. You can choose from row or col. In this example, we choose Col to show all names of the products.
-Input a number in each edit box below radio with respect to the region you selected. For example, 1 indicates the col of product
name, 2 indicates the col of product price, 8 indicates the col of manufacturing date.
-Select any cell in Col A (do not exceed the region you selected). For example, Col A Row 1 is selected, the name, price and
manufacturing date about product ID(6902223114059) will display in taskpane.