Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling data from other wb based on data to populate dropdown list | Excel Discussion (Misc queries) | |||
using selected data within a dropdown list to populate new list | Excel Programming | |||
Dropdown list to populate another sheet | Excel Programming | |||
Jump to Sheet Dropdown List | Excel Worksheet Functions | |||
adding data from one sheet to another sheet as a dropdown list bo. | Excel Discussion (Misc queries) |