The database includes products, product categories, suppliers of products and prices. Even if the data in the table is mixed, we can comfortably examine the products by grouping them by category and suppliers on linked drop-down lists , the data can be entered to other sheets.
Source codes and sample workbook here : Dependent drop down lists in Excel
