Finding records based on combo box

N

NHS

Hi Everyone

I have a spreadsheet in Excel 2003, which has approximately 600
records (or rows).

There are a number of values for each record, such as elecment code
description and group.

I have inserted a combo box onto the spreadsheet, but thats as far as
have got.

Ideally, I want to limit the number of rows based on what group i
selected from the combo box.

Any help is greatly appreciated.

Phi
 
D

Dave Peterson

You may want to consider dropping the combobox and using data|Filter|autofilter.

Select all your range
data|Filter|autofilter

Then you can use the dropdown arrow in any of those column headers to see/hide
what you want.

But there is a limit to the number of unique entries shown in the dropdown (it's
1000). But you can use a custom filter and still accomplish what you want.
 
Top