If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I setup a searchable database in excel
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel database to mail merge | BobBlueJay | General Discussion | 3 | September 7th, 2004 01:09 AM |
Access database created when opening Excel | bill Johnson | General Discussion | 1 | July 7th, 2004 09:48 PM |
Productkey problem when installing office 2003 on network | Stefan Schreurs | Setup, Installing & Configuration | 1 | June 1st, 2004 11:16 PM |
Excel 2002 Page Setup created in Excel 98 | Maia | Worksheet Functions | 0 | March 9th, 2004 12:46 AM |
Display Binary data ( an OLE object field in Access database) to Excel Cell | Koo | Worksheet Functions | 0 | October 9th, 2003 09:43 AM |