Your workbook design is counterproductive!
You need a main data input table, where you enter all inventory entries - with column for category.
When list of categories is limited and fixed, you can define Category column cells as Data Validation List based on categories list.
Otherwise it's better you have all Categories listed in separate table on separate worksheet, and create a Dynamic Named Range based on this table. Then you can define Category column cells in main table as Data Validation List based on this Named Range.
(Using Data Validation List prevents errors when you enter category for entry.)
Now you can use Autofilter on main table, to display only entries of certain category, or only entries with 'Yes' or 'No' as response or whatever combination of column values you ever want to define.
You also can design various report sheets. E.g. a sheet, where you select category and response, and an ODBC query returns matching records from main table.
|