Using Filter Command to Create MIS Sheets

You may need to create MIS for reporting certain data only out of the entire list of data that you may have in a table. For example, you may want certain set of people to know what items of stock are finished so that they can be re-ordered or what items have poor profitability.

Using the Filter Command you can create sheets that provide the relevant data automatically without you having to manually filter the data each time.