I know this isn't the ideal solution, but I am trying to find a way to provide an end user with a form that will search a range of cells and return a list of matching records for various criteria. The web-server that this will run on does not support Access or any advanced languages like Java, or I would do it in one of those. Can anyone point me in the right direction to create such a form and have it search and display all the results at once?

Thanks

Mike

Mike
EchoVue.com

__________________
Mike
EchoVue.com

One thing you could do would be to add a userform with a listbox on it, and populate the listbox with the data to display.

In any event, you are likely going to have to the heavy lifting yourself, establishing the formatting (so to speak) through code contained in an iterative loop.

You could create a label on the form, and change its .caption. (Better put scroll bars on the form if it is likely to get tall...)

I'll give it a whirl.

Thanks!

Mike

Mike
EchoVue.com

Quick (kind of) question... The user form makes sence, however I want to be able to filter the data from another sheet. The data is basically a list of medical doctors with their specialities and addresses. I want the user to enter the City and/or speciality and then populate a list of all matches with the same city and/or speciality. Does Excel have anything like a SQL query that I could build based on the button click event and then pull the information from a second sheet in an array or recordset or something?

Thanks

Mike

Mike
EchoVue.com

A simple lookup table would probably suffice.on the one shhet you put in the area/speciality and return the results on the current sheet then use asp to generate your html.