How do I setup a searchable database in excel

[Guest]

I am trying to setup a searchable database using excel. The data is pretty
massive (e.g. 250 columns and 300 rows). I have seen this done before. The
idea is to have an interface with either a drop-down menu or checklists to
call all of the data that match the desired criteria.

The best illustration that I can think of is an interface like the advanced
interface of ebay (but without the free text box). You can check-off a
variety of criteria and then it calls all of the data that match that
criteria.

I have played with the auto-filter button, but even with custom filters,
this does not allow me to select enough criteria. I think that Advanced
filters may be a possible solution, but I am finding it complicated to use.

VBA may be the best alternative.

Please think about this and respond with any suggestions. A
template/model/document that is similar would be much appreciated.

Thanks for all of the help,

Jon

 

[Frank Kabel]

Hi
have you tried using 'Data - Filter for this'?

--
Regards
Frank Kabel
Frankfurt, Germany

"Excel database search" <Excel database
(e-mail address removed)> schrieb im Newsbeitrag
news:[email protected]...

 

[Dave Peterson]

Excel also has a builtin feature under Data|Form.

But it's limited to 32 fields (IIRC).

But John Walkenbach has created an enhanced data|form. You can find it at:
http://j-walk.com/ss/dataform/index.htm

and John's comparisons between his version and excel's at:
http://j-walk.com/ss/dataform/features.htm