Dropdown list to populate sheet
 

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.

Dropdown list to populate sheet
 

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.

Dropdown list to populate sheet
 

Thanks Jim. I actually have my list currently in auto filter, but it's not
what I needed. I'm intending to have a brief summary on top of the page that
will sum/avg/wt.avg some of the columns. So the idea when the user select
the desired category, the sheet will be populated with that category's data,
and the summary section will be updated accordingly, and from there they can
print it out. Sorry I didn't explain that well on my first message.

Thanks.


"Jim Thomlinson" wrote:

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.