Have you looked at adding an autofilter

Data - Filter - AutoFilter
--
HTH...

Jim Thomlinson


"sahafi" wrote:

I have a sheet with about 38 columns and 600 rows. I need to have a comboBox,
list, form, etc where a user can select a category (I have 15 categories each
with 20-100 rows of data) and the sheet will populate the 38 columns with
only that category's data. What's the best way to approach this?


Thanks.