i have 5 categories and 10-30 set of records in each category.
i created a dropdownlist to select the category
while selecting the category respective records should be displayed
i have uploaded a sample excel file
Attached is an Excel 2003 solution that uses a command button on the worksheet that runs Visual Basic code and opens a form with a list box to display a list of the categories retrieved from Sheet2.
After you select a category from the list and click OK, rows in Sheet1 that fall outside of the category you choose are hidden, accomplished by Visual Basic code.
The workbook open event contains code that hides rows 2-100 in Sheet1, giving you a blank sheet and the command button to start with.