Drop-down filtering in Execl2000

[smithd]

Hi,
I'm trying to filter with drop-downs in Excel2000. I'd like to display all records for REQ only using the drop-down:

[drop-down]
REQ01
IN01
REQ02
IS01
IN02
REQ03

Any suggestions?

[rylo]

Hi

Not sure what you are chasing, but if it is an autofilter for items that start with REQ then select your range, data, Filter, autofilter, select the drop down, then custom, Begins With, REQ and it will filter out your entries.

HTH

rylo